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); }