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

posted @ 2011-07-08 10:35  敏捷学院  阅读(486)  评论(0)    收藏  举报