EntLib5.0DAAB(DataAccessApplicationBlock),数据访问程序块

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
using System.Data;

namespace TestEntLib5_0InFramework3_5
{
 class Program
 {
 static void Main(string[] args)
 {
 Database db = DatabaseFactory.CreateDatabase(); //创建一个默认的数据库对象

 //Database db = DatabaseFactory.CreateDatabase("DbConnString182"); //创建一个命名的数据库对象

 //1.ExecuteNonQuery
 /*
 DbCommand dbCmd = db.GetSqlStringCommand(
 @"INSERT INTO T_EntLib (name,birthday,email) VALUES(N'吴1','2008-12-23','a@qq.com');
 INSERT INTO T_EntLib (name,birthday,email) VALUES(N'吴2','2008-12-23','gga@qq.com');
 INSERT INTO T_EntLib (name,birthday,email) VALUES(N'吴3','2008-12-23','a@qq.com');
 INSERT INTO T_EntLib (name,birthday,email) VALUES(N'吴4','2008-12-23','a@qq.com');
 INSERT INTO T_EntLib (name,birthday,email) VALUES(N'吴5','2008-12-23','a@qq.com');");
 int iAffectedNum = db.ExecuteNonQuery(dbCmd); //返回影响的条数
 Console.WriteLine(iAffectedNum);
 */

 //2. ExecuteDataSet自动开启关闭Connection 

 //var sql = "SELECT TOP 10 * FROM sys_draw ORDER BY id DESC";
 /*
 var sql = "SELECT * FROM T_EntLib";

 DbCommand cmd = db.GetSqlStringCommand(sql);

 // No need to open the connection; just make the call.
 //	执行时监视：cmd.Connection.State
 DataSet ds = db.ExecuteDataSet(cmd);
 //在此处发现：cmd.Connection.State	Closed	System.Data.ConnectionState
 //说明自动关闭连接
 Console.WriteLine(ds.Tables[0].Rows.Count);
 int col = ds.Tables[0].Columns.Count;
 foreach (DataRow dr in ds.Tables[0].Rows)
 {
 for (int i = 0; i < col; i++)
 {
 Console.Write(dr[i].ToString());
 }
 Console.WriteLine();
 }
 */

 //3:ExecuteReader
 /**
 * If the Data Access Application Block methods close the connection before returning the DbDataReader,
 * the DbDataReader becomes useless to the client code. Instead, the DbDataReader methods indicate 
 * to the underlying ADO.NET call to automatically close the connection when the DbDataReader is disposed. 
 * 
 * */
 /*
 var sql = "SELECT * FROM T_EntLib";
 DbCommand cmd = db.GetSqlStringCommand(sql);
 using (IDataReader reader = db.ExecuteReader(cmd))
 {
 int col = reader.FieldCount;
 while (reader.Read())
 {
 for (int i = 0; i < col; i++)
 {
 Console.Write(reader[i].ToString());
 }
 Console.WriteLine();
 }
 } //在此处之后，发现 cmd.Connection.State 自动变为Closed.
 */

 //4: Retrieving Data as Objects 
 

 var sql = "SELECT * FROM T_EntLib";

 //var result = db.ExecuteSqlStringAccessor(sql); //使用默认的RowMapper

 IRowMapper < Info > rowMapper = MapBuilder.MapAllProperties()
 .MapByName(x => x.NAME)
 .DoNotMap(x => x.Email)
 .DoNotMap(x=>x.Birthday)
 .Build();
 var result = db.ExecuteSqlStringAccessor(sql, rowMapper); //使用自定义的RowMapper

 foreach (var item in result)
 {
 Console.WriteLine("ID={0},Name:{1},Birthday:{2},Email:{3}", item.Id, item.NAME, item.Birthday, item.Email);
 }
 Console.ReadKey();
 }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace TestEntLib5_0InFramework3_5
{
 public class Info
 {
 public int Id { get; set; }
 public string NAME { get; set; }
 public string Email { get; set; }
 public DateTime Birthday { get; set; }
 }
}

CREATE TABLE T_EntLib
(
	ID bigint IDENTITY,
	NAME nvarchar(50),
	Birthday datetime,
	Email varchar(50)
)