public static void InitDatabase(string hostname, string username, string password, string database)
{
if (!IsNullOrEmpty(m_ConnectionString))
return;
//Build an SQL connection string
var sqlString = new SqlConnectionStringBuilder()
{
DataSource = hostname,
InitialCatalog = database,
UserID = username,
Password = password,
ApplicationName = "EntityFramework",
MultipleActiveResultSets = true,
PersistSecurityInfo = true
};
//Build an entity framework connection string
var entityString = new EntityConnectionStringBuilder()
{
Provider = "System.Data.SqlClient",
Metadata = "res://*/BluffinMuffinLogs.csdl|res://*/BluffinMuffinLogs.ssdl|res://*/BluffinMuffinLogs.msl",
ProviderConnectionString = sqlString.ToString()
};
m_ConnectionString = entityString.ToString();
Task.Factory.StartNew(LogCommands);
}
/// <summary>
/// Builds an entity framework connection string
/// </summary>
/// <param name="ServerName">Server Name</param>
/// <param name="DatabaseName">Database Name</param>
/// <returns>connection string to use</returns>
public static string BuildConnectionString(string ServerName, string DatabaseName)
{
// Initialize the connection string builder for the
// underlying provider.
var Builder = new SqlConnectionStringBuilder();
// Set the properties for the data source.
Builder.DataSource = ServerName;
Builder.InitialCatalog = DatabaseName;
Builder.IntegratedSecurity = true;
// Initialize the EntityConnectionStringBuilder.
var EntityStringBuilder = new EntityConnectionStringBuilder();
//Set the provider name.
EntityStringBuilder.Provider = "System.Data.SqlClient";
// Set the provider-specific connection string.
EntityStringBuilder.ProviderConnectionString = Builder.ToString();
// Set the Metadata location.
EntityStringBuilder.Metadata = "res://*/";
//return the string now
return EntityStringBuilder.ToString();
}
public static string BuildEntityConnectionString(string connectionString, string modelName)
{
var builder = new EntityConnectionStringBuilder
{
Metadata = string.Format("res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", modelName),
Provider = "System.Data.SqlClient",
ProviderConnectionString = connectionString
};
return builder.ToString();
}
public static void SetConString()
{
DBConnectioin oDbConn = new DBConnectioin();
ConString = oDbConn.GetConString();
var Orig = System.Configuration.ConfigurationManager.ConnectionStrings["AspetProdEntities"].ConnectionString;
var ecs = new EntityConnectionStringBuilder(Orig);
ecs.ProviderConnectionString = ConString;
ConString = ecs.ToString();
// return bValidLogin;
}
public static string TradeConnectionString(string sqlConString
)
{
var entityBuilder = new EntityConnectionStringBuilder
{
Provider = "System.Data.SqlClient",
ProviderConnectionString = sqlConString,
Metadata = @"res://*/Trade.csdl|res://*/Trade.ssdl|res://*/Trade.msl"
};
return entityBuilder.ToString();
}
public static string GetEFConnectionString(DALISGDatabaseType databaseType)
{
var entityConnectionStringBuilder =
new EntityConnectionStringBuilder
{
Provider = "System.Data.SqlClient",
ProviderConnectionString = GetConnectionString(databaseType),
Metadata = GetEFConnectionStringMetadata(databaseType)
};
return entityConnectionStringBuilder.ToString();
}
void generateEntities() //use connection param to modify the connection string and dbcontext;
{ //to continue
string ip = this.ServerIp;
string username = this.ServerUsername;
string password = this.ServerPassword;
//Data Source=192.168.28.129;Initial Catalog=Dblibrary;Persist Security Info=True;User ID=sa;Password=19831122
String sqlConnectionString = "Data Source=" + ServerIp + ";Initial Catalog=Location;Persist Security Info=True;User ID=" + ServerUsername + ";Password="******"res://*/Models.Location.csdl|res://*/Models.Location.ssdl|res://*/Models.Location.msl";
eb.Provider = "System.Data.SqlClient";
eb.ProviderConnectionString = sqlConnectionString;
this.entitiesConnectionString=eb.ToString();
this.dbEntities = new LocationEntities(this.entitiesConnectionString);
}
public static string ToEntityConnectionString(this string val, string contextName)
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[val];
if (connectionString == null)
{
throw new Exception("No ConnectionString with name:" + val);
}
var entityBuilder = new EntityConnectionStringBuilder();
entityBuilder.Provider = connectionString.ProviderName;
entityBuilder.ProviderConnectionString = connectionString.ConnectionString;
entityBuilder.Metadata = String.Format(MetadataPattern, contextName);
return entityBuilder.ToString();
}
protected void EstablishEFConnection()
{
if (dataContext == null)
{
var entityBuilder = new EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings[connectionStringEF].ConnectionString);
var providerBuilder = DbProviderFactories.GetFactory(entityBuilder.Provider).CreateConnectionStringBuilder();
providerBuilder.ConnectionString = entityBuilder.ProviderConnectionString;
providerBuilder.Add("Password", sqlLoginPassword);
entityBuilder.ProviderConnectionString = providerBuilder.ToString();
dataContext = new FinanceMonitorEntities(entityBuilder.ToString());
//using System.Data.Entity.Core.Objects;
//for error on next page zzz
}
}
public string BuildEntityConnectionString(string sqlConnectionString)
{
EntityConnectionStringBuilder entityConnectionStringBuilder = new EntityConnectionStringBuilder();
// Hard-code the provider name (since we only have a SQL Server source)
entityConnectionStringBuilder.Provider = "System.Data.SqlClient";
// Set the provider-specific connection string
entityConnectionStringBuilder.ProviderConnectionString =
new SqlConnectionStringBuilder(sqlConnectionString).ToString();
// Set the resource metadata location
entityConnectionStringBuilder.Metadata =
"res://*/ExperimentModel.csdl|res://*/ExperimentModel.ssdl|res://*/ExperimentModel.msl";
return entityConnectionStringBuilder.ToString();
}
public static string GetConnectString()
{
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = "192.168.1.3";
sqlBuilder.InitialCatalog = "Product";
sqlBuilder.UserID = "Mondiland";
sqlBuilder.Password = "******";
sqlBuilder.MultipleActiveResultSets = true;
sqlBuilder.ApplicationName = "EntityFramework";
EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
entityBuilder.Provider = "System.Data.SqlClient";
entityBuilder.ProviderConnectionString = sqlBuilder.ToString();
entityBuilder.Metadata = "res://*/ProductModule.csdl|res://*/ProductModule.ssdl|res://*/ProductModule.msl";
return entityBuilder.ToString();
}
public SGCoopSTEntities()
: base("name=SGCoopSTEntities")
{
string providerName = "System.Data.SqlClient";
string serverName = "10.10.11.115";
string databaseName = "SGCoopST";
string password="******";
string userid = "sa";
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = false;
sqlBuilder.Password = password;
sqlBuilder.UserID = userid;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = providerName;
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString;
// Set the Metadata location.
entityBuilder.Metadata = @"res://*/GOLDMEM.Entity.GMModel.csdl
|res://*/GOLDMEM.Entity.GMModel.ssdl
|res://*/GOLDMEM.Entity.GMModel.msl";
EntityConnection enCon = new EntityConnection(entityBuilder.ToString());
if (enCon.State== System.Data.ConnectionState.Closed)
{
enCon.Open();
}
}
void Temp()
{
#region EntityConnectionCreationAndUsage
EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder
{
Provider = "System.Data.SqlClient",
ProviderConnectionString = "the database connection string",
Metadata = @"res://*/MySample.csdl|res://*/MySample.ssdl|res://*/MySample.msl"
};
EntityConnection entityConn = new EntityConnection(entityBuilder.ToString());
using (MySampleContainer ctx = new MySampleContainer(entityConn))
{
//use the DbContext as required
}
#endregion
}
private static string GenerateConnectionString(string connectionString)
{
// Create the connection string builder
var sqlBuilder = new SqlConnectionStringBuilder(connectionString);
// Build the connection string
var providerString = sqlBuilder.ToString();
// Initialize the connection string builder
var entityBuilder = new EntityConnectionStringBuilder
{
ProviderConnectionString = providerString,
Provider = "System.Data.SqlClient",
Metadata = @"res://*/Core.Contexts.WingTipTicketModel.csdl|
res://*/Core.Contexts.WingTipTicketModel.ssdl|
res://*/Core.Contexts.WingTipTicketModel.msl"
};
return entityBuilder.ToString();
}
public static void updateConnectionStrings(string orgId)
{
try
{
string dbName = "drcardrive_" + orgId;
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
scsb.DataSource = HOST + "\\SQLEXPRESS";
scsb.InitialCatalog = dbName;
scsb.MultipleActiveResultSets = true;
scsb.ApplicationName = "EntityFramework";
if (HOST == "." && USERNAME == "")
{
scsb.IntegratedSecurity = true;
}
else
{
scsb.UserID = USERNAME;
scsb.Password = PASSWORD;
}
ecsb = new EntityConnectionStringBuilder();
ecsb.Provider = "System.Data.SqlClient";
ecsb.ProviderConnectionString = scsb.ToString();
ecsb.Metadata = "res://*/DrCarDriveModel.csdl|res://*/DrCarDriveModel.ssdl|res://*/DrCarDriveModel.msl";
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
connectionStringsSection.ConnectionStrings["drcardriveEntities"].ConnectionString = ecsb.ToString();
config.Save();
ConfigurationManager.RefreshSection("connectionStrings");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private static void test()
{
// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = ".";
string databaseName = "AdventureWorks";
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = true;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = providerName;
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString;
// Set the Metadata location.
entityBuilder.Metadata = @"res://*/AdventureWorksModel.csdl|
res://*/AdventureWorksModel.ssdl|
res://*/AdventureWorksModel.msl";
Console.WriteLine(entityBuilder.ToString());
using (EntityConnection conn =
new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
Console.WriteLine("Just testing the connection.");
conn.Close();
}
}
public override void OnInitialized()
{
var sqlBuilder = new SqlConnectionStringBuilder
{
DataSource = Configuration.Host,
InitialCatalog = Configuration.InstanceName,
IntegratedSecurity = false,
UserID = Configuration.Username,
Password = Configuration.Password
};
var entityBuilder = new EntityConnectionStringBuilder
{
Provider = "System.Data.SqlClient",
ProviderConnectionString = sqlBuilder.ToString(),
Metadata =
@"res://*/Database.EntityFramework.KonfDBModel.csdl|res://*/Database.EntityFramework.KonfDBModel.ssdl|res://*/Database.EntityFramework.KonfDBModel.msl"
};
_configurationStore = new ConfigurationDataStore(entityBuilder.ToString());
}
