Search code examples
asp.netsqldemonorthwind

Current way to setup ASP.NET site with demo data?

I need to set up ASP.NET and connect it to some demo (northwind) data.

Considering all the versions of SQL, what is the most current /efficient way to get a database into a project and do a select against it?

This question arose once we discovered we could download a MDB and a MDF format of northwind...

Solution

  • asp.net is loaded with tons of how to's for started. One section specifically goes into the different ways of interacting with a database. I choose the old fashion DAL which they outline at http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-cs.

    There are now plenty of new ways using LINQ and other methods, but u can look at all the options yourself.