EnterpriseLibrary数据访问(1)使用SQL直接访问数据库

本演练直接使用SQL语句来访问数据库

 

1.配置文件

01	<configuration>

02	<configSections>

03	<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />

04	</configSections>

05	<dataConfiguration defaultDatabase="QuickStarts Instance" />

06	<connectionStrings>

07	<add name="QuickStarts Instance" connectionString="Database=EntLibQuickStarts;Server=(local);Integrated Security=SSPI;"

08	providerName="System.Data.SqlClient" />

09	</connectionStrings>

10	</configuration>

2.引用文件

Microsoft.Practices.EnterpriseLibrary.Common.dll

Microsoft.Practices.EnterpriseLibrary.Data.dll

Microsoft.Practices.ServiceLocation.dll

 

3.代码

01	private void mnuCount_Click(object sender, System.EventArgs e)        {

02	// TODO: Count Customers

03	Database db = EnterpriseLibraryContainer.Current.GetInstance<Database>("QuickStarts Instance");

04

05	int count = (int)db.ExecuteScalar(

06	CommandType.Text,

07	"SELECT Count(*) FROM Customers");

08

09	string message = string.Format("There are {0} customers in the database", count.ToString());

10	MessageBox.Show(message);

11

}

12

13	private void mnuLoad_Click(object sender, System.EventArgs e)

14

{

15	// TODO: Load Customers

16

17	Database db

18	= EnterpriseLibraryContainer.Current.GetInstance<Database>();

19

20	DataSet ds = db.ExecuteDataSet(

21	CommandType.Text,

22	"SELECT * From Customers");

23

24	dataGrid1.DataSource = ds.Tables[0];

25

}

代码下载：http://dev.mjxy.cn/a-entlib-Direct-access-to-the-database-using-SQL.aspx