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?
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.