本文整理汇总了C#中System.Data.Common.DbConnectionStringBuilder.Add方法的典型用法代码示例。如果您正苦于以下问题:C# DbConnectionStringBuilder.Add方法的具体用法?C# DbConnectionStringBuilder.Add怎么用?C# DbConnectionStringBuilder.Add使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbConnectionStringBuilder
的用法示例。
在下文中一共展示了DbConnectionStringBuilder.Add方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: instancesComboBox_SelectedIndexChanged
private void instancesComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string server = (string)instancesComboBox.SelectedItem;
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("Data Source", server);
builder.Add("Initial Catalog", "master");
builder.Add("Integrated Security", "SSPI");
using ( SqlConnection conn = new SqlConnection(builder.ConnectionString) )
{
SqlCommand cmd = new SqlCommand("select name from sys.databases", conn);
conn.Open();
using ( SqlDataReader reader = cmd.ExecuteReader() )
{
List<string> dbs = new List<string>();
while ( reader.Read() )
{
dbs.Add(reader.GetString(0));
}
dbsComboBox.DataSource = dbs;
}
}
}
示例2: Main
static void Main()
{
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "wjzgis");
dcsBuilder.Add("Password", "wjzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
//dcsBuilder.Add("License Path", licPath);
//若路径中存在空格,则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
Configuration config = new Configuration();
config.AddDirectory(new System.IO.DirectoryInfo( System.IO.Path.Combine(Application.StartupPath, "DataMapping")));
config.Properties["connection.connection_string"] = conStr;
NHibernate.ISessionFactory sFactory = config.BuildSessionFactory();
NHibernate.ISession session = sFactory.OpenSession();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
示例3: GetConnectionString
/// <summary>
/// get default connection string.
/// </summary>
/// <returns>Connection String</returns>
public static string GetConnectionString()
{
DbConnectionStringBuilder connectBuilder = new DbConnectionStringBuilder();
connectBuilder.Add("Data Source", "localhost");
connectBuilder.Add("Database", "bookstore");
connectBuilder.Add("User ID", "root");
connectBuilder.Add("Password", "v*elocIpEd");
return connectBuilder.ConnectionString;
}
示例4: ReplaceEnlistInConnectionString
/// <summary>
/// Replaces any existing 'enlist' parameter in the connection string
/// with a value indicating that manual enlist is necessary.
/// </summary>
/// <remarks>
/// ODP.NET supports 3 values for 'enlist'; 'true', 'false' and 'dynamic'.
/// 'dynamic' effectively works the same as 'false' in System.Data.OracleClient.
/// </remarks>
protected override void ReplaceEnlistInConnectionString(DbConnectionStringBuilder dbConnectionStringBuilder)
{
if (dbConnectionStringBuilder.ContainsKey("enlist"))
dbConnectionStringBuilder.Remove("enlist");
dbConnectionStringBuilder.Add("enlist", "dynamic");
}
示例5: GetConnectionString
public string GetConnectionString(AbstractConnection connection) {
if (string.IsNullOrEmpty(ServerProperty))
return string.Empty;
var builder = new DbConnectionStringBuilder { { ServerProperty, connection.Server } };
if (!string.IsNullOrEmpty(connection.Database)) {
builder.Add(DatabaseProperty, connection.Database);
}
if (!String.IsNullOrEmpty(connection.User)) {
builder.Add(UserProperty, connection.User);
builder.Add(PasswordProperty, connection.Password);
} else {
if (!String.IsNullOrEmpty(TrustedProperty)) {
builder.Add(TrustedProperty, true);
}
}
if (PersistSecurityInfoProperty != string.Empty && connection.PersistSecurityInfo != string.Empty) {
builder.Add(PersistSecurityInfoProperty, connection.PersistSecurityInfo);
}
if (connection.Port <= 0)
return builder.ConnectionString;
if (PortProperty == string.Empty) {
builder[ServerProperty] += "," + connection.Port;
} else {
builder.Add("Port", connection.Port);
}
return builder.ConnectionString;
}
示例6: Form1
public Form1()
{
InitializeComponent();
DataTable dtProviderFactorys = DbProviderFactories.GetFactoryClasses();
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "hzzgis");
dcsBuilder.Add("Password", "hzzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
if (!System.IO.File.Exists(licPath))
licPath = CretateDDTekLic.CreateLic();
dcsBuilder.Add("License Path", licPath);
//若路径中存在空格,则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
DDTek.Oracle.OracleConnection orclConnection = new DDTek.Oracle.OracleConnection(conStr);
DDTek.Oracle.OracleCommand cmd = new DDTek.Oracle.OracleCommand();
DDTek.Oracle.OracleDataAdapter adapter = new DDTek.Oracle.OracleDataAdapter();
adapter.SelectCommand = cmd;
DbDataAdapter dAdapter = adapter;
DbCommand dbCommand = dAdapter.SelectCommand;
orclConnection.Open();
//Configuration config = new Configuration();
//ISessionFactory pFactory = config.BuildSessionFactory();
//ISession pSession= pFactory.OpenSession(orclConnection as IDbConnection);
//DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
//IDbConnection dbConn = factory.CreateConnection();
//if (dbConn != null)
// MessageBox.Show("Connection Created");
//Conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password=" + PWD + ";pooling = true;Unicode=True";
IDbConnection dbConn=new System.Data.OleDb.OleDbConnection();
string Server = "sunzvm-lc", Port = "1521", Service = "sunz", User = "hzzgis", PWD = "hzzgis";
//dbConn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password=" + PWD + ";pooling = true;Unicode=True";
dbConn.ConnectionString = "Provider=MSDAORA.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password=" + PWD + ";pooling = true;Unicode=True";
try
{
dbConn.Open();
}
catch(Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
示例7: EquivalentToTest
public void EquivalentToTest ()
{
builder.Add (SERVER, SERVER_VALUE);
DbConnectionStringBuilder sb2 = new DbConnectionStringBuilder ();
sb2.Add (SERVER, SERVER_VALUE);
bool value = builder.EquivalentTo (sb2);
Assert.IsTrue (value, "builder comparision does not work!");
// negative tests
sb2.Add (SERVER + "1", SERVER_VALUE);
value = builder.EquivalentTo (sb2);
Assert.IsFalse (value, "builder comparision does not work for not equivalent strings!");
}
示例8: ContainsKey
public void ContainsKey ()
{
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
builder = new DbConnectionStringBuilder (false);
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
builder = new DbConnectionStringBuilder (true);
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
}
示例9: Remove
public void Remove ()
{
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
builder = new DbConnectionStringBuilder (false);
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
builder = new DbConnectionStringBuilder (true);
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
}
示例10: TryGetValueTest
public void TryGetValueTest ()
{
object value = null;
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
builder = new DbConnectionStringBuilder (false);
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
builder = new DbConnectionStringBuilder (true);
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
}
示例11: okButton_Click
private void okButton_Click(object sender, EventArgs e)
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("Data Source", instancesComboBox.Text);
builder.Add("Initial Catalog", dbsComboBox.Text);
builder.Add("Integrated Security", "SSPI");
ConnectionString = builder.ConnectionString;
DialogResult = DialogResult.OK;
Close();
}
示例12: initialize
private void initialize(string path, bool hasHeaders, bool hasMixedData)
{
string fullPath = Path.GetFullPath(path);
string extension = Path.GetExtension(path);
if (!File.Exists(fullPath))
throw new FileNotFoundException("File could not be found.", fullPath);
string tempFileName = Path.GetTempFileName();
File.Copy(fullPath, tempFileName, true);
// Reader Settings
HasHeaders = hasHeaders;
HasMixedData = hasMixedData;
switch (extension)
{
case ".xls": Version = "Excel 8.0"; break; // Excel 95-2003
case ".xlsx": Version = "Excel 12.0"; break; // Excel 2007+
default: throw new ArgumentException("File type could not be determined by file extension.", "path");
}
if (IntPtr.Size == 4 && extension == ".xls")
Provider = "Microsoft.Jet.OLEDB.4.0"; // for x86/95-2003
else Provider = "Microsoft.ACE.OLEDB.12.0"; // for x64/95-2007+
var strBuilder = new DbConnectionStringBuilder();
strBuilder.Add("Provider", Provider);
strBuilder.Add("Data Source", tempFileName);
strBuilder.Add("Extended Properties", Version + ";" +
"HDR=" + (HasHeaders ? "Yes" : "No") + ';' +
"Imex=" + (HasMixedData ? "2" : "0") + ';');
strConnection = strBuilder.ToString();
}
示例13: ReplaceEnlistInConnectionString
/// <summary>
/// Replaces any existing 'enlist' parameter in the connection String
/// with a value indicating that manual enlist is necessary.
/// </summary>
protected virtual void ReplaceEnlistInConnectionString(DbConnectionStringBuilder dbConnectionStringBuilder)
{
if (dbConnectionStringBuilder.ContainsKey("enlist"))
dbConnectionStringBuilder.Remove("enlist");
dbConnectionStringBuilder.Add("enlist", false);
}
示例14: TryGetValueTest
public void TryGetValueTest()
{
object value = null;
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
_builder = new DbConnectionStringBuilder(false);
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
_builder = new DbConnectionStringBuilder(true);
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
}
示例15: GetConnectionString
private static string GetConnectionString(string fileOrConnectionString)
{
if (fileOrConnectionString.IndexOf('=') > 0)
{
return fileOrConnectionString;
}
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
if (fileOrConnectionString.EndsWith(".mdf", StringComparison.OrdinalIgnoreCase))
{
builder.Add("AttachDBFileName", fileOrConnectionString);
builder.Add("Server", @"localhost\sqlexpress");
builder.Add("Integrated Security", "SSPI");
builder.Add("User Instance", "true");
builder.Add("MultipleActiveResultSets", "true");
}
else
{
if (!fileOrConnectionString.EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
return fileOrConnectionString;
}
builder.Add("Data Source", fileOrConnectionString);
}
return builder.ToString();
}