public TestDapperCoreRepository(ITestDbProvider provider) { _provider = provider; UpsertMapper = new TestUpsertCommandContainer(typeof(test_dapper_core_item)); _tableName = UpsertMapper.ModelName; SchemeTableName = $"[dbo].{_tableName}"; UpsertSingleItemTemplate = _createUpSertTemplateWhithOutput(); UpdateSingleItemTemplate = _createUpdateItemByIdTemplate(); }
public TestDapperCore() { var opts = Options.Create(new TestConnectionOptions { Test = TestDataConnection.TestConnecttion }); _provider = new TestDbProvider(opts); _repo = new TestDapperCoreRepository(_provider); }
protected TestDapperPlusRepository(ITestDbProvider provider, string tableName, string schemeName = null) { _povider = provider; _tableName = tableName; if (schemeName == null) { schemeName = DefaultScheme; } SchemeTableName = _povider.GetTableName(_tableName, schemeName); _mapper = DapperPlusManager.Entity <TEntity>().Table(_tableName).Identity(x => x.Id).BatchSize(100000); }
public TestUserDapperPlusRepository(ITestDbProvider povider) : base(povider, "user") { }
public static string SqlDelete(this ITestDbProvider provider, string tableName) { return($"DELETE FROM {tableName} WHERE Id = @id"); }
public static string GetProcedureName(this ITestDbProvider provider, string procedureName, string scheme = DefaultScheme) { return(provider.GetTableName(procedureName, scheme)); }
public static string GetTableName(this ITestDbProvider provider, string tableName, string scheme = DefaultScheme) { return($"[{scheme}].[{tableName}]"); }
public static string SqlGetAll(this ITestDbProvider provider, string tableName) { return($"SELECT * FROM {tableName}"); }
public static string SqlGetById(this ITestDbProvider provider, string tableName) { return($"SELECT top 1 * FROM {tableName} WHERE Id = @id"); }
public static string SqlDeleteAll(this ITestDbProvider provider, string tableName) { return($"DELETE FROM {tableName}"); }
public TestUserMesasgeDapperPlusRepository(ITestDbProvider provider) : base(provider, "userMessage") { DapperPlusManager.Entity <TestUserMesasge>().Table(_tableName).Identity(x => x.Id); }