Microsoft Technology Ruby on Rails Equivalent. . .?

[gberz3]

Hi All,

I'm in the process of acquiring a client that is in need of tying in a web application to an MS Access DB. Originally I was going to use Ruby on Rails, but when the requirement to support the Access database came up, it changed things a bit. So, that leads to my question: Are there currently any MS technologies (.NET or otherwise) on par with RoR for database integration and "ease of use"?

Regards

[sr71000]

not ms based but i'm pretty sure php will support access files

[amtrac24]

if your using msaccess i would highly suggest using a .net framework language. Either VB or C# with asp.net would be your best and easiest choice. The server side code with the debugging makes it easier to work with then PHP.

[gberz3]

if your using msaccess i would highly suggest using a .net framework language. Either VB or C# with asp.net would be your best and easiest choice. The server side code with the debugging makes it easier to work with then PHP.

That's what I'm thinking. I'll look into them. Do you know if any of the .NET technologies support Object Relational Mapping?

[amtrac24]

not sure because i never used Object Relational Mapping....can you give me a "real world" example of Object Relational Mapping....

[gberz3]

Yes, in RoR it uses ORM. Basically it maps and handles both objects and relationships from the database. There is no need to initialize objects for writing or retrieval from the database, and you can do things like:

Person = People.find_by_first_name("carl", :first_occurrence)
Person.car = Car.new("bmw")
Person.save

Obviously that's not actual Ruby code, but that's the gist. The Rails framework handles the DB connection and management. There's no need to explicitly write any SQL (although it's still possible).

[amtrac24]

i havent seen anything like this in .net that I am aware of.

[gberz3]

I see. Well, it would be nice to know what MS has to offer in that way, or what other technologies might "easily" tie into MS Access. I believe I lack sufficient information about current MS tech to ask the proper questions.

Thank you for your help.