public MsSqlModelContext Create()
{
var connectionFactory = new MsSqlDatabaseContextFactory();
var desktopDbConnectionParameters = new DbConnectionParameters
{
DbServerUrl = "(localdb)\\v11.0",
DbInstanceName = "TestCodeFirst",
IsOsUser = true,
ConnectionUserName = "",
ConnectionUserPassword = ""
};
return(new MsSqlModelContext(connectionFactory.CreateDbConnection(desktopDbConnectionParameters)));
}
protected RepositoryBase(DbConnectionParameters dbConnection, string collectionName, IKeyFor <T> keyProvider)
{
KeyProvider = keyProvider;
DbConnection = dbConnection;
CollectionName = collectionName;
Client = new DocumentClient(new Uri(DbConnection.EndpointUri), DbConnection.PrimaryKey);
DocumentCollectionUri = UriFactory.CreateDocumentCollectionUri(DbConnection.DbName, CollectionName);
Client.CreateDatabaseIfNotExistsAsync(new Database {
Id = DbConnection.DbName
}).GetAwaiter().GetResult();
Client.CreateDocumentCollectionIfNotExistsAsync(UriFactory.CreateDatabaseUri(DbConnection.DbName),
new DocumentCollection {
Id = CollectionName
}).GetAwaiter().GetResult();
}
public DbConnection CreateDbConnection(DbConnectionParameters dbConnectionParameters)
{
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = dbConnectionParameters.DbServerUrl,
InitialCatalog = dbConnectionParameters.DbInstanceName,
IntegratedSecurity = true,
MultipleActiveResultSets = true
};
if (!dbConnectionParameters.IsOsUser)
{
connectionStringBuilder.UserID = dbConnectionParameters.ConnectionUserName;
connectionStringBuilder.Password = dbConnectionParameters.ConnectionUserPassword;
connectionStringBuilder.IntegratedSecurity = false;
}
if (dbConnectionParameters.IsLocalDatabase)
{
connectionStringBuilder.AttachDBFilename = String.Format("{0}\\{1}.mdf", dbConnectionParameters.LocalDbFileCatalog, dbConnectionParameters.DbInstanceName);
}
return(new SqlConnection(connectionStringBuilder.ToString()));
}
public void CreateDataBase()
{
var contextFactory = new MsSqlDatabaseContextFactory();
var parameters = new DbConnectionParameters
{
DbServerUrl = "(localdb)\\v11.0",
DbInstanceName = "TestCodeFirst",
IsOsUser = true,
ConnectionUserName = "",
ConnectionUserPassword = ""
};
ModelContextBase context = contextFactory.CreateModelContext(contextFactory.CreateDbConnection(parameters));
context.Database.CommandTimeout = 800;
if (context.Database.Exists())
{
context.Database.Delete();
}
context.Database.Initialize(false);
}
public UserRepository(DbConnectionParameters dbConnection, IKeyFor <User> keyProvider)
: base(dbConnection, "Users", keyProvider)
{
}
public ContributionRepository(DbConnectionParameters dbConnection, IKeyFor <Contribution> keyProvider)
: base(dbConnection, "Contributions", keyProvider)
{
}
public NoteRepository(DbConnectionParameters dbConnection, IKeyFor <Note> keyProvider)
: base(dbConnection, "Notes", keyProvider)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="CosmosRepositoryModule"/> class.
/// </summary>
public CosmosRepositoryModule(IConfiguration configuration) : base(configuration)
{
_dbConnectionParams = configuration?.GetSection("CosmosDbParams")?.Get <DbConnectionParameters>();
}
