Entity Framework is considered the way to go now, but some devs use NHibernate instead. I suggest you look at Code First Entity Framework rather than Model First since the database is already defined.
>Hi,
>
>For years I have been using my ASP.NET application with VFP database (using OleDb driver and OleDbDataAdapter). I have not even looked an ASP.NET book in several years.
>
>Now I need to change the code to get the data from SQL Server. The book on ASP.NET I am using was published in 2002. And the example code in the book uses SqlDataAdapter. Is this still the best practice of accessing SQL Server data from an ASP.NET application?
>
>TIA.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer