.NET Ramblings - Brian Noyes' Blog - MSDN Webcast: Implement a Data Access Layer with the Visual Studio 2005 DataSet Designer slides and demos

Friday, July 14, 2006

MSDN Webcast: Implement a Data Access Layer with the Visual Studio 2005 DataSet Designer slides and demos

Here are the slides and demos from last week's webcast. Keep in mind that you will need to add a Modified DateTime column and respective stored procedures to your database to be able to run the code as it was demo'ed in the webcast. The demo code includes my CodeSmith templates for generating those stored procedures and also one for making the coumn modification scripts for you if you want to do it to all the tables in your database that are transactional. There is also a SQL script just for doing the Employees table in Northwind, which was all I used in the demos.

Slides

Demos

.NET | Languages and Tools | Speaking

Friday, July 14, 2006 2:13:51 PM (GMT Standard Time, UTC+00:00)

Comments [2] |

Wednesday, August 16, 2006 3:03:04 PM (GMT Standard Time, UTC+00:00)

Using sql 2000 database I run the sql script in your demo fine using Query Analyzer to add the storedprocs and modified column. Just wondering is there a better way to run the sql script from within vs2005 against the northwind database - if I try it using new query i get script errors with ALTER and GO statements? Do i have to modify the script to run it from within vs2005?

Thanks.

Wednesday, August 16, 2006 3:33:45 PM (GMT Standard Time, UTC+00:00)

You need to have Northwind in your SQL 2005 instance, which is not part of the sample DBs for 2005, but the scripts to create it are included in this download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

The scripts work fine for 2005 even though it is titled 2000.

Brian

Comments are closed.