locked
Enterprise Library 5 RRS feed

  • Question

  • User-1881192663 posted

    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. 

    Tuesday, March 1, 2011 2:54 PM

All replies

  • User-2135385890 posted

            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;
            }

    Tuesday, March 1, 2011 7:08 PM
  • User-1881192663 posted

    Thanks.  Actually this much I have done, but I want to see a complete structure of DAL developed in Enterprise Library 5.

    Wednesday, March 2, 2011 12:14 AM