本文整理汇总了C#中System.Data.Common.DbConnectionStringBuilder类的典型用法代码示例。如果您正苦于以下问题:C# DbConnectionStringBuilder类的具体用法?C# DbConnectionStringBuilder怎么用?C# DbConnectionStringBuilder使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbConnectionStringBuilder类属于System.Data.Common命名空间,在下文中一共展示了DbConnectionStringBuilder类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateConfigPerEndpointConnectionStringProvider
IConnectionStringProvider CreateConfigPerEndpointConnectionStringProvider(LocalConnectionParams localConnectionParams)
{
const string transportConnectionStringPrefix = "NServiceBus/Transport/";
var configConnectionStrings =
connectionStrings
.Where(x => x.Name.StartsWith(transportConnectionStringPrefix))
.Select(x =>
{
string schema;
var connectionString = x.ConnectionString.ExtractSchemaName(out schema);
var endpoint = x.Name.Replace(transportConnectionStringPrefix, String.Empty);
var connectionInfo = EndpointConnectionInfo.For(endpoint).UseSchema(schema);
var localConnectionStringBuilder = new DbConnectionStringBuilder { ConnectionString = localConnectionParams.ConnectionString };
var overriddenConnectionStringBuilder = new DbConnectionStringBuilder { ConnectionString = connectionString };
if (!localConnectionStringBuilder.EquivalentTo(overriddenConnectionStringBuilder))
{
connectionInfo = connectionInfo.UseConnectionString(connectionString);
}
return connectionInfo;
})
.ToArray();
return new CollectionConnectionStringProvider(configConnectionStrings, localConnectionParams);
}
示例2: ResolveInstance
public static InstanceInfo ResolveInstance(
DbConnectionStringBuilder builder,
bool isOdbc,
QuerySource dbType
)
{
InstanceInfo instance;
if (dbType == QuerySource.SQLite || dbType == QuerySource.NetworkInformation)
{
instance = ResolveNonDatabase(
builder.ConnectionString,
dbType
);
}
else
{
instance = ResolveDatabase(
builder,
dbType,
isOdbc
);
}
return instance;
}
示例3: EnsureDatabase
private static void EnsureDatabase()
{
using (var connection = SqlConnections.NewByKey("Default"))
try
{
connection.Open();
}
catch
{
var cb = new DbConnectionStringBuilder();
cb.ConnectionString = SqlConnections.GetConnectionString("Default").ConnectionString;
var catalog = cb["Initial Catalog"];
cb["Initial Catalog"] = null;
cb["AttachDBFilename"] = null;
using (var serverConnection = new SqlConnection(cb.ConnectionString))
{
serverConnection.Open();
serverConnection.Execute(String.Format(
@"CREATE DATABASE [{0}] ON PRIMARY (Name = N'{0}', FILENAME = '{1}\{0}.mdf') LOG ON (NAME = N'{0}_log', FILENAME = '{1}\{0}.ldf');",
catalog, HostingEnvironment.MapPath("~/App_Data")));
}
SqlConnection.ClearAllPools();
}
RunMigrations();
}
示例4: Test
public void Test()
{
try
{
var connectionString = new DbConnectionStringBuilder();
connectionString["Data Source"] = "ANNE\\OJB_NET";
connectionString["Initial Catalog"] = "unittest";
connectionString["Integrated Security"] = "SSPI";
connectionString["MultipleActiveResultSets"] = true;
var connection = new SqlConnection(connectionString.ConnectionString);
var context = new Context {Connection = connection, IsSqlCeConnectionBug = true};
context.UpdateDatabase();
var address = new Address {Id = 1, Text = "5th Ave, City23"};
var customer = new Customer {Id = 1, Name = "Cust co ldt.", Address = address};
context.Container.Address.Add(address);
context.Container.Customer.Add(customer);
//context.SaveChanges();
var customers = context.Container.Customer.Where(c => c.Id == 1).Where(c => c.Id == 1);
var customersFound = customers.ToArray();
var customerFound = customers.Single();
}
catch(Exception)
{
Debugger.Break();
throw;
}
}
示例5: BaseNode
public BaseNode(string text, DbConnectionStringBuilder builder,DataType nodetype)
: base(text)
{
this.ConnectionStringBuilder = builder;
this.datatype = nodetype;
this.Nodes.Add(new DummyNode());
}
示例6: IngresMetadataReader
public IngresMetadataReader(string connectionStr)
{
_connectionString = connectionStr;
DbConnectionStringBuilder connStr = new DbConnectionStringBuilder();
connStr.ConnectionString = _connectionString;
DatabaseName = connStr["Database"] as String;
}
示例7: 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());
}
示例8: Init
public Task Init(string name, IProviderRuntime providerRuntime, IProviderConfiguration config)
{
string connectionStringName = config.Properties["ConnectionStringName"];
if (string.IsNullOrEmpty(connectionStringName))
{
this.Log.Info("Starting RavenDB Storage Provider InMemory");
return this.InMemoryMode();
}
var settings = ConfigurationManager.ConnectionStrings[connectionStringName];
var connectionStringBuilder = new DbConnectionStringBuilder
{
ConnectionString = settings.ConnectionString
};
object url;
if (connectionStringBuilder.TryGetValue("Url", out url))
{
this.Log.Info("Starting RavenDB Storage Provider attached to server {0}", url);
return this.ServerMode(connectionStringName);
}
object dataDir;
if (connectionStringBuilder.TryGetValue("DataDir", out dataDir))
{
this.Log.Info("Starting RavenDB Storage Provider embedded in directory {0}", dataDir);
return this.LocalMode(connectionStringName);
}
return TaskDone.Done;
}
示例9: 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");
}
示例10: NpgsqlMetadataReader
public NpgsqlMetadataReader(string connectionStr)
{
this._connectionString = connectionStr;
DbConnectionStringBuilder connStr = new DbConnectionStringBuilder();
connStr.ConnectionString = _connectionString;
DatabaseName = connStr["Database"] as String;
}
示例11: DomainCredential
//TODO: Custom config section?
//TODO: Combine constructors
public DomainCredential(string connectionString)
{
//TODO: Custom parser?
var builder = new DbConnectionStringBuilder();
builder.ConnectionString = connectionString;
object[] value = new object[6];
builder.TryGetValue("NetBIOS", out value[0]);
builder.TryGetValue("Domain", out value[1]);
builder.TryGetValue("Container", out value[2]);
builder.TryGetValue("Username", out value[3]);
builder.TryGetValue("Password", out value[4]);
builder.TryGetValue("SecureConnection", out value[5]);
if (String.IsNullOrWhiteSpace(value[0] as string))
throw new ArgumentNullException("netbios");
if (String.IsNullOrWhiteSpace(value[1] as string))
throw new ArgumentNullException("domain");
if (String.IsNullOrWhiteSpace(value[2] as string))
throw new ArgumentNullException("container");
NetBIOS = value[0] as string;
Domain = value[1] as string;
Container = value[2] as string;
Username = value[3] as string;
Password = value[4] as string;
SecureConnection = bool.Parse(value[5] as string ?? "False");
}
示例12: ConnectionStringBuilder
public ConnectionStringBuilder(GenDatabase db)
{
GenDatabase = db;
DbConnectionStringBuilder = GenDatabase.DbProviderFactory.CreateConnectionStringBuilder();
if (db.GenProviderType == GenProviderType.OleDb)
((OleDbConnectionStringBuilder)DbConnectionStringBuilder).Provider = GenDatabase.OleDbName;
}
示例13: DbProvider
protected DbProvider(string connectionString, System.Data.Common.DbProviderFactory dbProviderFactory)
{
this.dbConnectionStringBuilder = new DbConnectionStringBuilder();
this.dbConnectionStringBuilder.ConnectionString = connectionString;
this.dbProviderFactory = dbProviderFactory;
}
示例14: 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;
}
}
}
示例15: GetConnectionString
public static string GetConnectionString()
{
System.Data.Common.DbConnectionStringBuilder sb= new DbConnectionStringBuilder();
sb.ConnectionString = ConfigurationManager.ConnectionStrings["trackDBEntities2"].ConnectionString;
return sb["provider connection string"].ToString();
}