public static string CreateEntityString(EntitySetting setting)
{
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = "System.Data.SqlClient";
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = CreateConnectionString(setting);
// Set the Metadata location.
entityBuilder.Metadata = setting.Metadata;
return entityBuilder.ToString();
}
public static string CreateConnectionString(EntitySetting setting, bool security = true, bool multi = true)
{
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = setting.DataSource;
sqlBuilder.InitialCatalog = setting.DataCatalog;
if (!(string.IsNullOrEmpty(setting.Username) && string.IsNullOrEmpty(setting.Password)))
{
sqlBuilder.UserID = setting.Username;
sqlBuilder.Password = setting.Password;
}
sqlBuilder.IntegratedSecurity = security;
sqlBuilder.MultipleActiveResultSets = multi; //allows you to have multiple datareaders at once
// Build the SqlConnection connection string.
return sqlBuilder.ToString();
}
public static AccountEntity GetAccountEntity(EntitySetting setting)
{
string connectionstring = ConnectionStringbuilder.CreateEntityString(setting);
return new AccountEntity(connectionstring);
}
public static WorldEntity GetWorldEntity(EntitySetting setting)
{
string connectionstring = ConnectionStringbuilder.CreateEntityString(setting);
return new WorldEntity(connectionstring);
}
