I have an existing SQL Server database and I want to make a site that will work with it. I have worked previsouly with RoR and ASP NET MVC 3 but in these technologies the databases seem to be built-in in application itself. Given my limitation (using an existing database) what's the best technology to achieve this?
1
-
I'm not clear on what problem you have with RoR nor ASP.NET MVC.kenny– kenny2012-07-03 21:16:31 +00:00Commented Jul 3, 2012 at 21:16
Add a comment
|
3 Answers
Yeah, I have to agree with pst... this is a rather broad 'question'. We use C# with ASP.NET 4.0 for most of our new websites. Then we use a WCF data layer that talks to our SQL database and we pass custom objects from WCF to the website to work with. Abstracting your site and data layer provides many benefits for us but that all depends on the scope of your project. WCF also allows you quite a bit of flexibility when it comes to how you develop the front end. While we are consuming it from ASP.NET websites in some areas, other places consume it using PHP.
Comments
This is an opinion of course
The first thing you need is freetds,
Then you need to install the SQLServer Adapter
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter.git
And then TidyTDS:
https://github.com/rails-sqlserver/tiny_tds.git
This post may help:
Comments
If you mean that you've always used ORM that generated the db from code and not the other way around then what you need might be Linq to SQL but you can also achieve this with many other ORMs.
