public TodoDatabase(ProviderType providerType, string dbConnectionString)
{
SqlFuManager.Configure(cfg =>
{
switch (providerType)
{
case ProviderType.SqlServer2012:
cfg.AddProfile(new SqlServer2012Provider(SqlClientFactory.Instance.CreateConnection), dbConnectionString);
break;
case ProviderType.Sqlite:
cfg.AddProfile(new SqliteProvider(SqlClientFactory.Instance.CreateConnection), dbConnectionString);
break;
default:
throw new ArgumentException("Not supported provider type", nameof(providerType));
}
cfg.ConfigureTableForPoco <TodoItem>(info =>
{
info.TableName = new TableName("todo_item");
info.Property(t => t.Id).IsAutoincremented();
info.Property(t => t.IsComplete).MapToColumn("is_complete");
info.Property(t => t.UserId).MapToColumn("user_id");
});
cfg.ConfigureTableForPoco <User>(info =>
{
info.TableName = new TableName("user");
info.Property(u => u.Id).IsAutoincremented();
info.IgnoreProperties(u => u.TodoItems);
});
});
dbFactory = SqlFuManager.GetDbFactory();
}
static Setup()
{
LogManager.OutputTo(s => System.Diagnostics.Debug.WriteLine(s));
SqlFuManager.Configure(c =>
{
c.AddProfile(new SqlServer2012Provider(SqlClientFactory.Instance.CreateConnection), Connex);
});
}
static Setup()
{
LogManager.OutputTo(s => System.Diagnostics.Debug.WriteLine(s));
SqlFuManager.Configure(c =>
{
c.AddProfile(new SqlServer2012Provider(SqlClientFactory.Instance.CreateConnection), Connex);
// c.AddProfile(new SqliteProvider(SQLiteFactory.Instance.CreateConnection),"Data Source = mydb.db; Version = 3;","sqlite");
});
}
public async Task <List <Client> > GetClients()
{
System.Threading.CancellationToken ct = default;
List <Client> result;
using (DbConnection db = SqlFuManager.GetDbFactory <IPdfGeneratorDb>().Create())
{
result = await db.QueryAsync <Client>(ct, SqlQueries.GetClients);
}
return(result);
}
private void InitializeSqlFu()
{
//Add SqlFu service to the service container:
var dbContext = _config.GetConnectionString("PDFGeneratorDB");
SqlFuManager.Configure(c =>
{
c.AddProfile <IPdfGeneratorDb>(new SqlServer2012Provider(SqlClientFactory.Instance.CreateConnection), dbContext);
c.OnException = (cmd, ex) => _logger.LogError(cmd.FormatCommand(), ex);
});
}
public static IConfigureEventStore UseSqlite(this IConfigureEventStore store, Func <DbConnection> factory, string cnx, string schema = null)
{
SqlFuManager.Configure(d =>
{
d.AddProfile(new SqlFu.Providers.Sqlite.SqliteProvider(factory), cnx, "sqlite");
RegisterSqlFuConfig(d, schema);
});
var provider = new SqliteProvider(SqlFuManager.GetDbFactory("sqlite"));
store.WithProvider(provider);
return(store);
}
public static IDbFactory DbFactory(DbProvider provider, string cnx, Action <SqlFuConfig> config = null)
{
LogManager.OutputTo(w => Trace.WriteLine(w));
var c = new SqlFuConfig();
SqlFuManager.UseLogManager();
c.ConfigureTableForPoco <IdempotencyTools.IdemStore>(g =>
{
g.TableName = new TableName(IdempotencyTools.DefaultTableName);
});
config?.Invoke(c);
return(c.CreateFactoryForTesting(provider, cnx));
}
public MssqlCreateTableBuilderTests()
{
LogManager.OutputToConsole();
SqlFuManager.UseLogManager();
_db = Setup.GetConnection();
}
public static IDbFactory GetConnection() => SqlFuManager.GetDbFactory();
public static DbConnection GetConnection() => SqlFuManager.GetDbFactory(
//#if SqlServer
//#elif Sqlite
// "sqlite"
//#endif
).Create();
