Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 02, 2011 04:14 AM by raoofahmedkhan
Member
145 Points
113 Posts
Mar 01, 2011 06:54 PM|LINK
Hi,
I want to use Enterprise Library 5 DAAB in my development activity, kindly provide me a link for a suitable example of creating DAL using Enterprise Library 5.
Thanks in advance.
Contributor
2081 Points
418 Posts
Mar 01, 2011 11:08 PM|LINK
public static DataSet GetItems() { Database db = DatabaseFactory.CreateDatabase("connString"); DbCommand dbCommand = db.GetStoredProcCommand("GetAllFromDB"); db.AddInParameter(dbCommand, "@Param1", DbType.Int32, 100); db.AddInParameter(dbCommand, "@Param1", DbType.Boolean, false); DataSet ds = db.ExecuteDataSet(dbCommand); dbCommand.Connection.Close(); dbCommand.Connection.Dispose(); dbCommand.Dispose(); return ds; }
Mar 02, 2011 04:14 AM|LINK
Thanks. Actually this much I have done, but I want to see a complete structure of DAL developed in Enterprise Library 5.
raoofahmedkh...
Member
145 Points
113 Posts
Enterprise Library 5
Mar 01, 2011 06:54 PM|LINK
Hi,
I want to use Enterprise Library 5 DAAB in my development activity, kindly provide me a link for a suitable example of creating DAL using Enterprise Library 5.
Thanks in advance.
Deeshal
Contributor
2081 Points
418 Posts
Re: Enterprise Library 5
Mar 01, 2011 11:08 PM|LINK
public static DataSet GetItems()
{
Database db = DatabaseFactory.CreateDatabase("connString");
DbCommand dbCommand = db.GetStoredProcCommand("GetAllFromDB");
db.AddInParameter(dbCommand, "@Param1", DbType.Int32, 100);
db.AddInParameter(dbCommand, "@Param1", DbType.Boolean, false);
DataSet ds = db.ExecuteDataSet(dbCommand);
dbCommand.Connection.Close();
dbCommand.Connection.Dispose();
dbCommand.Dispose();
return ds;
}
raoofahmedkh...
Member
145 Points
113 Posts
Re: Enterprise Library 5
Mar 02, 2011 04:14 AM|LINK
Thanks. Actually this much I have done, but I want to see a complete structure of DAL developed in Enterprise Library 5.