private static void InitializeRepoDb() { var provider = MixService.GetEnumConfig <MixDatabaseProvider>(MixConstants.CONST_SETTING_DATABASE_PROVIDER); switch (provider) { case MixDatabaseProvider.MSSQL: SqlServerBootstrap.Initialize(); break; case MixDatabaseProvider.MySQL: MySqlBootstrap.Initialize(); break; case MixDatabaseProvider.PostgreSQL: PostgreSqlBootstrap.Initialize(); break; case MixDatabaseProvider.SQLITE: SqLiteBootstrap.Initialize(); break; default: SqLiteBootstrap.Initialize(); break; } }
static void Main(string[] args) { // SQL Server Connection for RepoDb SqlServerBootstrap.Initialize(); // Instantiate Menu and WelcomeText Menu menu = new Menu(); WelcomeText welcomeText = new WelcomeText(); // Method for displaing Welcome screen (see Helper folder for refference) welcomeText.Print(); /*Navigation to Menu or Exit of the application. * If 'Enter' is pressed -> Menu * else if 'Escape' || another key pressed -> close app*/ switch (Console.ReadKey().Key) { case ConsoleKey.Enter: menu.Index(); break; case ConsoleKey.Escape: { } break; } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { SqlServerBootstrap.Initialize(); PostgreSqlBootstrap.Initialize(); MySqlBootstrap.Initialize(); #region dependency injection services.AddTransient <IDatabaseConnectionFactory, NorthWindDbConnectionFactory>(); services.AddTransient <IDatabaseConnectionFactory, AdemBlogDbConnectionFactory>(); services.AddTransient <IDatabaseConnectionFactory, FinansDbConnectionFactory>(); services.AddTransient <IDatabaseConnectionFactory, BookStoreDbConnectionFactory>(); services.AddTransient <ICategoryService, CategoryManager>(); services.AddTransient <ICategoryDal, CategoryDal>(); services.AddTransient <ICashboxService, CashboxManager>(); services.AddTransient <ICashboxDal, CashboxDal>(); services.AddTransient <ITagService, TagManager>(); services.AddTransient <ITagDal, TagDal>(); services.AddTransient <IPostService, PostManager>(); services.AddTransient <IPostDal, PostDal>(); services.AddTransient <IBookService, BookManager>(); services.AddTransient <IBookDal, BookDal>(); #endregion dependency injection services.AddControllersWithViews(); }
/// <summary> /// Initialize the creation of the database. /// </summary> public static void Initialize() { // Get the connection string var connectionStringForMaster = Environment.GetEnvironmentVariable("REPODB_CONSTR_MASTER", EnvironmentVariableTarget.Process); var connectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process); // Master connection ConnectionStringForMaster = (connectionStringForMaster ?? @"Server=(local);Database=master;Integrated Security=False;User Id=michael;Password=Password123;"); // RepoDb connection ConnectionStringForRepoDb = (connectionString ?? @"Server=(local);Database=RepoDb;Integrated Security=False;User Id=michael;Password=Password123;"); // Set the proper values for type mapper TypeMapper.Add(typeof(DateTime), System.Data.DbType.DateTime2, true); // Initialize the SqlServer SqlServerBootstrap.Initialize(); // Create the database first CreateDatabase(); // Create the schemas CreateSchemas(); // Create the tables CreateTables(); // Create the stored procedures CreateStoredProcedures(); }
public void Setup() { BaseSetup(); SqlServerBootstrap.Initialize(); TypeMapper.Add(typeof(DateTime), DbType.DateTime2, true); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddControllers(); SqlServerBootstrap.Initialize(); var connection = Configuration.GetValue <string>("ConnectionString"); services.AddSingleton(new WarehouseRepository(connection)); services.AddSingleton <IWarehouseObjectRepo>(new WarehouseObjectRepo(connection)); services.AddSingleton <IWarehouseInlineRepo>(new WarehouseInlineRepo(connection)); services.AddSingleton <IWarehouseProcedureRepo>(new WarehouseProcedureRepo(connection)); services.AddSingleton <IWarehouseProvider>(c => new WarehouseProvider(connection, c.GetService <ICache>())); services.AddSingleton <IWareHouseUpdator>(c => new WareHouseUpdator(connection, c.GetService <ITrace>())); services.AddSingleton <IWareHouseDeletor>(new WareHouseDeletor(connection)); services.AddSingleton <ICache, MemoryCache>(); services.AddSingleton <ITrace, CustomTrace>(); }
public void OpenConnection(string connString) { var conn = _config.GetConnectionString(connString); this._dbconn = new SqlConnection(conn); this._dbconn.Open(); SqlServerBootstrap.Initialize(); }
private static void RepoDbConfigInit() { FluentMapper.Entity <Text>() .Table("[dbo].[Texts]") .Primary(e => e.Id) .Identity(e => e.Id) .Column(e => e.Value, "[TextValue]"); SqlServerBootstrap.Initialize(); }
public UnitOfWork(IUnitOfWorkConfiguration configuration) { SqlServerBootstrap.Initialize(); _config = configuration; Task.Run( async() => { await BeginTransactionAsync(); }).ConfigureAwait(false).GetAwaiter().GetResult(); }
public void GlobalSetup() { SqlServerBootstrap.Initialize(); var indexOfFirstParameter = Sql.IndexOf("@", StringComparison.Ordinal); if (Sql.Substring(0, indexOfFirstParameter) != SqlEFInterpolated.ToString().Substring(0, indexOfFirstParameter)) { throw new Exception(); } }
public static void Initialize() { // Initialize SqlServerBootstrap.Initialize(); // Models FluentMapper .Entity <DirectoryCompany>() .Table("[directory].[Companies]"); FluentMapper .Entity <SurveyCompany>() .Table("[survey].[Companies]"); }
/// <summary> /// Initialize the creation of the database. /// </summary> public static void Initialize() { // Master connection ConnectionStringForMaster = Environment.GetEnvironmentVariable("REPODB_CONSTR_MASTER", EnvironmentVariableTarget.Process) ?? @"Server=(local);Database=master;Integrated Security=SSPI;TrustServerCertificate=True;"; // RepoDb connection ConnectionStringForRepoDb = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process) ?? @"Server=(local);Database=RepoDb;Integrated Security=SSPI;TrustServerCertificate=True;"; // Initialize the SqlServer SqlServerBootstrap.Initialize(); // Create the database first CreateDatabase(); // Create the tables CreateTables(); }
/// <summary> /// Initialize the creation of the database. /// </summary> public static void Initialize() { // Get the connection string var connectionStringForMaster = Environment.GetEnvironmentVariable("REPODB_CONSTR_MASTER", EnvironmentVariableTarget.Process); var connectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process); // Master connection ConnectionStringForMaster = (connectionStringForMaster ?? @"Server=(local);Database=master;Integrated Security=False;User Id=michael;Password=Password123;"); // RepoDb connection ConnectionStringForRepoDb = (connectionString ?? @"Server=(local);Database=RepoDb;Integrated Security=False;User Id=michael;Password=Password123;"); // Initialize the SqlServer SqlServerBootstrap.Initialize(); // Create the database first CreateDatabase(); // Create the tables CreateTables(); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddControllers(); services.AddHealthChecks(); SqlServerBootstrap.Initialize(); services.AddDbContext <DevTrainingContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"))); services.AddScoped <IUnitOfWork, UnitOfWork>(); services.AddSingleton <IResponseDto>(new ResponseDto(Configuration.GetConnectionString("DevTrainingContext"))); services.AddSwaggerGen(c => { c.SwaggerDoc("v1", new OpenApiInfo { Title = "DevTraining API", Version = "v1" }); c.EnableAnnotations(); }); services.AddAutoMapper(typeof(Startup)); }
public static void Initialize() { // Master connection ConnectionStringForMaster = Environment.GetEnvironmentVariable("REPODB_CONSTR_MASTER", EnvironmentVariableTarget.Process) ?? @"Server=(local);Database=master;Integrated Security=SSPI;TrustServerCertificate=True;"; // RepoDb connection ConnectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process) ?? @"Server=(local);Database=RepoDbTest;Integrated Security=SSPI;TrustServerCertificate=True;"; // Initialize the SqlServer SqlServerBootstrap.Initialize(); // Set the DateTime type TypeMapper.Add(typeof(DateTime), DbType.DateTime2, true); // Create databases CreateDatabase(); // Create tables CreateTables(); }
// DISCLAIMER: I am using System.Diagnostics.Stopwatch to measure performance as it is // faster and it suits my presentation purposes. For real-life scenarios, I suggest using // Benchmark.NET. // // I am also using the latest preview versions of all frameworks. // These may perform differently compared to stable releases. // // You may find a better ORM performance comparison here: // https://github.com/FransBouma/RawDataAccessBencher/ public static void Main() { // LINQ to DB DataConnection.DefaultSettings = new CatsDataConnection.DataSettings(); // RepoDB SqlServerBootstrap.Initialize(); ClassMapper.Add <Cat>("[dbo].[Cats]"); ClassMapper.Add <Owner>("[dbo].[Owners]"); // DataSeeder.Seed(); TooManyQueriesBattle.Fight(); // LazyLoadingTooManyQueriesBattle.Fight(); // SelectSpecificColumnsBattle.Fight(); // IncorrectDataLoadingBattle.Fight(); // InnerQueryBattle.Fight(); // DeleteBattle.Fight(); // DataSeeder.DeleteAndSeed(); // ColdAndWarmQueriesBattle.Fight(); // CompiledQueriesBattle.Fight(); // ChangeTrackingBattle.Fight(); }
public static void Initialize() { // Check the connection string var connectionStringForMaster = Environment.GetEnvironmentVariable("REPODB_CONSTR_MASTER", EnvironmentVariableTarget.Process); var connectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process); // Master connection ConnectionStringForMaster = (connectionStringForMaster ?? @"Server=(local);Database=master;Integrated Security=False;User Id=michael;Password=Password123;"); // RepoDb connection ConnectionString = (connectionString ?? @"Server=(local);Database=RepoDbTest;Integrated Security=False;User Id=michael;Password=Password123;"); // Initialize the SqlServer SqlServerBootstrap.Initialize(); // Set the DateTime type TypeMapper.Map(typeof(DateTime), DbType.DateTime2, true); // Create databases CreateDatabase(); // Create tables CreateTables(); }
public void GlobalSetup() { SqlServerBootstrap.Initialize(); }
public void Setup() { BaseSetup(); SqlServerBootstrap.Initialize(); ClassMapper.Add <Post>("Posts"); }
public CryptoCurrencyDb(string connectionString) { _connectionString = connectionString; SqlServerBootstrap.Initialize(); CryptoCurrencyDbSetup = new CryptoCurrencyDbSetup(connectionString); }
public void Initialize() { SqlServerBootstrap.Initialize(); }
public void Setup() { SqlServerBootstrap.Initialize(); PostgreSqlBootstrap.Initialize(); }
static void Bootstrap() { SqlServerBootstrap.Initialize(); JobStorage.Current = new MemoryStorage(); }
/// <summary> /// Initializes the current bencher instance. /// </summary> public override void Initialize() { base.Initialize(); SqlServerBootstrap.Initialize(); }
public ServiceRepoDb(IConfiguration config) { _config = config; SqlServerBootstrap.Initialize(); }
/// <summary> /// SqlServerCommandProvider constructor. /// </summary> public SqlServerCommandProvider() { SqlServerBootstrap.Initialize(); }