// The values being assigned to the StringBuilder members are set previously/not shown
SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder();
connStringBuilder.DataSource = dataSource;
connStringBuilder.InitialCatalog = databaseName;
connStringBuilder.Encrypt = true;
connStringBuilder.TrustServerCertificate = false;
connStringBuilder.UserID = userName;
connStringBuilder.Password = password;
using (SqlConnection conn = new SqlConnection(connStringBuilder.ToString()))
{
using (SqlCommand command = conn.CreateCommand())
{
conn.Open();
command.CommandText =
"INSERT INTO T1 (col1, col2) values (1, 'string 1'), (2, 'string 2'), (3, 'string 3')";
int rowsAdded = command.ExecuteNonQuery();
}
conn.Close();
}
尝试使用SqlConnectionStringBuilder, SqlConnection
和SqlCommand
时,它们无法被识别或解析。 我需要安装单独的ADO.NET软件包才能使其工作,还是怎么回事?
更新
通过将System.Data.dll
添加到我的项目引用中(从我的机器上,来自C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.5
),我可以使这些类得到识别/解析,但仍然会出现编译时错误,即:
错误 1:程序集“System、Version=4.0.0.0、Culture=neutral、PublicKeyToken=b77a5c561934e089”中引用的基类或接口“System.ComponentModel.Component”,被类型“System.Data.Common.DbConnection”无法解析 c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework.NETFramework\v4.5\System.Data.dll
和:
错误 2:程序集“System、Version=4.0.0.0、Culture=neutral、PublicKeyToken=b77a5c561934e089”中引用的基类或接口“System.ComponentModel.Component”,被类型“System.Data.Common.DbCommand”无法解析 c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework.NETFramework\v4.5\System.Data.dll
更新2
将SQL.Data作为引用后,不同的问题阻止了该应用程序的编译,即:
在mscorlib.dll模块中找不到System.SystemException类型。
将SQL.Data从引用中删除可消除该问题。