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