Does DAAB auto make SQL commands itself?

Topics: Data Access Application Block
Feb 2, 2007 at 11:04 AM
Edited Feb 2, 2007 at 11:06 AM
I used to use sqlDataAdapter and sqlCommandBuilder to make InsertCommand,DeleteCommand and UpdataCommand automatically,and now I found I must input SQL commands by myself or use Stored Procedure.
I wonder if there is some method to make commands automatically?
Feb 2, 2007 at 1:22 PM
The DAAB does not auto make SQL Commands for you. You could use the SqlCommandBuilder or you could use the TableAdapters. There are also plenty of code generators around that can help you create the CRUD statements for a table.

The Web Service Software Factory contains the Data Access Guidance Package ( which uses the DAAB ) that will create stored procedures for every table in a database as well as repository classes. I talk about it here:

Web Services Software Factory Data Access Guidance Package

A bunch of good tutorials for ASP.NET and Table Adapters here:

http://www.asp.net/learn/dataaccess/default.aspx?tabid=63

Regards,

Dave

______________________

David Hayden
Microsoft MVP C#
May 27, 2007 at 6:52 AM
I am still working on this
But may still of some use

http://www.codeproject.com/useritems/Parameter_DiscoveryV292.asp