本文整理汇总了C#中System.Data.Common.DbConnectionStringBuilder类的典型用法代码示例。如果您正苦于以下问题:C# DbConnectionStringBuilder类的具体用法?C# DbConnectionStringBuilder怎么用?C# DbConnectionStringBuilder使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbConnectionStringBuilder类属于System.Data.Common命名空间,在下文中一共展示了DbConnectionStringBuilder类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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);
}
开发者ID:adamralph,项目名称:NServiceBus.SqlServer,代码行数:26,代码来源:ConnectionConfig.cs
示例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;
}
开发者ID:saycale,项目名称:MSSQLServerAuditor,代码行数:26,代码来源:InstanceInfoResolver.cs
示例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();
}
开发者ID:dalowery70,项目名称:Serenity-Tutorials,代码行数:28,代码来源:SiteInitialization.cs
示例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;
}
}
开发者ID:hahoyer,项目名称:HWsqlass.cs,代码行数:29,代码来源:Class1.cs
示例5: BaseNode
public BaseNode(string text, DbConnectionStringBuilder builder,DataType nodetype)
: base(text)
{
this.ConnectionStringBuilder = builder;
this.datatype = nodetype;
this.Nodes.Add(new DummyNode());
}
开发者ID:Tony-Liang,项目名称:CodeGenernate,代码行数:7,代码来源:DataBasesTree.cs
示例6: IngresMetadataReader
public IngresMetadataReader(string connectionStr)
{
_connectionString = connectionStr;
DbConnectionStringBuilder connStr = new DbConnectionStringBuilder();
connStr.ConnectionString = _connectionString;
DatabaseName = connStr["Database"] as String;
}
开发者ID:NumericTechnology,项目名称:KPCodeGen.Net,代码行数:7,代码来源:IngresMetadataReader.cs
示例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());
}
开发者ID:hy1314200,项目名称:HyDM,代码行数:26,代码来源:Program.cs
示例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;
}
开发者ID:ReubenBond,项目名称:orleans.storageprovider.ravendb,代码行数:33,代码来源:RavenDBStorageProvider.cs
示例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");
}
开发者ID:JuRogn,项目名称:OA,代码行数:15,代码来源:OdpResourceProvider.cs
示例10: NpgsqlMetadataReader
public NpgsqlMetadataReader(string connectionStr)
{
this._connectionString = connectionStr;
DbConnectionStringBuilder connStr = new DbConnectionStringBuilder();
connStr.ConnectionString = _connectionString;
DatabaseName = connStr["Database"] as String;
}
开发者ID:NumericTechnology,项目名称:KPCodeGen.Net,代码行数:7,代码来源:NpgsqlMetadataReader.cs
示例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");
}
开发者ID:blinds52,项目名称:Owin.Security.ActiveDirectoryLDAP,代码行数:30,代码来源:DomainCredential.cs
示例12: ConnectionStringBuilder
public ConnectionStringBuilder(GenDatabase db)
{
GenDatabase = db;
DbConnectionStringBuilder = GenDatabase.DbProviderFactory.CreateConnectionStringBuilder();
if (db.GenProviderType == GenProviderType.OleDb)
((OleDbConnectionStringBuilder)DbConnectionStringBuilder).Provider = GenDatabase.OleDbName;
}
开发者ID:alberthoekstra,项目名称:PVBeanCounter,代码行数:7,代码来源:ConnectionStringBuilder.cs
示例13: DbProvider
protected DbProvider(string connectionString, System.Data.Common.DbProviderFactory dbProviderFactory)
{
this.dbConnectionStringBuilder = new DbConnectionStringBuilder();
this.dbConnectionStringBuilder.ConnectionString = connectionString;
this.dbProviderFactory = dbProviderFactory;
}
开发者ID:daywrite,项目名称:EApp,代码行数:7,代码来源:DbProvider.cs
示例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;
}
}
}
开发者ID:tomasr,项目名称:sqltrackingquerysample,代码行数:25,代码来源:SelectDbForm.cs
示例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();
}
开发者ID:daaaasdev,项目名称:trackerparser,代码行数:7,代码来源:Helper.cs
示例16: GetConnectionInformationsFrom
/// <summary>
/// This function returns login and password of user for a passed NpgsqlConnection
/// </summary>
/// <param name="connection">the current opened DbConnection</param>
/// <param name="login">returned login corresponding to the NpgsqlConnection passed</param>
/// <param name="password">returned password corresponding to the NpgsqlConnection passed</param>
/// <returns>true if succeed, false otherwise (connection null or not opened)</returns>
public static bool GetConnectionInformationsFrom(
IDbConnection connection,
out string login,
out string password)
{
login = string.Empty;
password = string.Empty;
if ((connection != null) && (connection.State == System.Data.ConnectionState.Open))
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = connection.ConnectionString;
if (builder != null)
{
object value = null;
bool result = builder.TryGetValue("User Id", out value);
if (result)
{
login = value.ToString();
}
result &= builder.TryGetValue("Password", out value);
if (result)
{
password = value.ToString();
}
builder.Clear();
return result;
}
}
return false;
}
开发者ID:gilprime,项目名称:nPgTools,代码行数:42,代码来源:Utils.cs
示例17: CheckAssertions
protected void CheckAssertions(string connectionString)
{
DbConnectionStringBuilder dbConnection = new DbConnectionStringBuilder { ConnectionString = connectionString };
foreach (ConnectionStringSetting setting in StringSettings)
{
if (dbConnection.ContainsKey(setting.SettingName))
{
AssertState.Equal(setting.ExpectedValue, dbConnection[setting.SettingName].ToString());
}
else
{
throw new AssertionException(string.Format("Connection String setting [{0}] not found", setting.SettingName));
}
}
if (dbConnection.Keys != null)
AssertState.Equal(StringSettings.Count, dbConnection.Keys.Count);
else
{
throw new AssertionException("No StringSetting values were found");
}
if (CheckConnectivity)
using (SqlConnection sqlConnection = (new SqlConnection(connectionString)))
sqlConnection.Open();
}
开发者ID:radicalgeek,项目名称:Testing.Smoke,代码行数:27,代码来源:ConnectionStringTest.cs
示例18: 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;
}
开发者ID:modulexcite,项目名称:Transformalize,代码行数:34,代码来源:ConnectionStringProperties.cs
示例19: GetConnectionProvider
/// <summary>
/// Gets the provider information stored on the connection string
/// </summary>
/// <param name="connection">The connection object to get the connection string from</param>
/// <returns>An string providing the provider information</returns>
public static String GetConnectionProvider(DbConnection connection)
{
object result = String.Empty;
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = connection.ConnectionString;
builder.TryGetValue("Provider", out result);
return result == null ? string.Empty : (string)result;
}
开发者ID:WebMAPTestUser,项目名称:SKS,代码行数:13,代码来源:ADOConnectionSettingsHelper.cs
示例20: GetDataSourceFilePath
private static string GetDataSourceFilePath(DbConnectionStringBuilder builder, string connectionString)
{
builder.ConnectionString = connectionString;
if (!builder.ContainsKey("Data Source"))
{
throw new ArgumentException("A 'Data Source' parameter was expected in the supplied connection string, but it was not found.");
}
return ConnectionStringHelper.ResolveDataSourceFilePath(builder["Data Source"].ToString());
}
开发者ID:aracen74,项目名称:Cerritosoft.Pdf.Test,代码行数:9,代码来源:ConnectionStringHelper.cs
注:本文中的System.Data.Common.DbConnectionStringBuilder类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论