本演练直接使用SQL语句来访问数据库
1.配置文件
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" /> |
05 | < dataConfiguration defaultDatabase = "QuickStarts Instance" /> |
07 | < add name = "QuickStarts Instance" connectionString = "Database=EntLibQuickStarts;Server=(local);Integrated Security=SSPI;" |
08 | providerName = "System.Data.SqlClient" /> |
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) { |
03 | Database db = EnterpriseLibraryContainer.Current.GetInstance<Database>( "QuickStarts Instance" ); |
05 | int count = ( int )db.ExecuteScalar( |
07 | "SELECT Count(*) FROM Customers" ); |
09 | string message = string .Format( "There are {0} customers in the database" , count.ToString()); |
10 | MessageBox.Show(message); |
13 | private void mnuLoad_Click( object sender, System.EventArgs e) |
18 | = EnterpriseLibraryContainer.Current.GetInstance<Database>(); |
20 | DataSet ds = db.ExecuteDataSet( |
22 | "SELECT * From Customers" ); |
24 | dataGrid1.DataSource = ds.Tables[0]; |
代码下载:http://dev.mjxy.cn/a-entlib-Direct-access-to-the-database-using-SQL.aspx