Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand("SELECT * FROM Users"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { // read data } }
DbCommand dbCommand = db.GetStoredProcCommand("AddNewUser"); db.AddInParameter(dbCommand, "@username", DbType.String, "NewUser"); db.AddInParameter(dbCommand, "@password", DbType.String, "password"); db.ExecuteNonQuery(dbCommand);In conclusion, Microsoft.Practices.EnterpriseLibrary.Data is a package/library for data access that simplifies interactions with databases and stored procedures, hence it is a Common Library.