public SqliteBuilder(
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver) : base(
tableNameResolver,
columnNameResolver)
{
}
public BaseSqlBuilder(
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver)
{
this.tableNameResolver = tableNameResolver;
this.columnNameResolver = columnNameResolver;
}
public TSqlBuilder(
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver) : base(
tableNameResolver,
columnNameResolver)
{
this.schemaResolver = new DefaultSchemaResolver(DefaultSchema);
}
public TSqlBuilder(
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver,
ISchemaResolver schemaResolver) : base(
tableNameResolver,
columnNameResolver)
{
this.schemaResolver = schemaResolver;
}
public SqliteDataContext(
SqliteConnectionProvider connectionProvider,
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver) : base(
connectionProvider,
new SqliteBuilder(tableNameResolver, columnNameResolver),
new SqlCache())
{
}
public MySqlDataContext(
MySqlConnectionProvider connectionProvider,
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver) : base(
connectionProvider,
new MySqlBuilder(tableNameResolver, columnNameResolver),
new SqlCache())
{
}
public SqlServerDataContext(
string connectionString,
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver) : base(
new SqlServerConnectionProvider(connectionString),
new TSqlBuilder(tableNameResolver, columnNameResolver),
new SqlCache())
{
}
public void Dispose()
{
if (_connection.State != ConnectionState.Closed)
{
_transaction?.Rollback();
_connection.Close();
_connection = null;
NameResolver = null;
}
}
public DubonContext(IDbConnection connection, ITableNameResolver resolver = null)
{
_connection = connection;
_connection.Open();
if (resolver == null)
{
resolver = new DefaultTableNameResolver();
}
NameResolver = resolver;
}
public SqlServerDataContext(
SqlServerConnectionProvider connectionProvider,
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver,
ISchemaResolver schemaResolver) : base(
connectionProvider,
new TSqlBuilder(tableNameResolver, columnNameResolver, schemaResolver),
new SqlCache())
{
}
public SqlServerDataContext(
SqlServerConnectionProvider connectionProvider,
ITableNameResolver tableNameResolver,
IColumnNameResolver columnNameResolver,
string defaultSchema) : base(
connectionProvider,
new TSqlBuilder(tableNameResolver, columnNameResolver, defaultSchema),
new SqlCache())
{
}
public override Boolean CanSupplyValue(
ParameterInfo pi, IComponentContext context, out Func <Object> valueProvider)
{
valueProvider = null;
if (pi.ParameterType != typeof(String) && pi.Name != "tableName")
{
return(false);
}
valueProvider = () =>
{
ITableNameResolver tableNameResolver = context.Resolve <ITableNameResolver>();
Type entityType = pi.Member.DeclaringType.GetGenericArguments()[0];
String tableName = tableNameResolver.GetTableName(entityType);
return(tableName);
};
return(true);
}
public static IDataContext SetupDataContext(
Type dataContextType,
ITableNameResolver tableNameResolver = null,
IColumnNameResolver columnNameResolver = null)
{
// check whether we are dealing with a type that implement IDataContext
if (!IsDataContext(dataContextType))
{
throw new ArgumentException($"Type {dataContextType.Name} does not implement IDataContext.");
}
// return the data context for the given type
if (IsInMemory(dataContextType))
{
return(new InMemoryDataContext());
}
else if (IsSqlServer(dataContextType))
{
MsSqlTestHelper.CreateTestDatabase(TestContext.CurrentContext.Test.FullName);
return(new SqlServerDataContext(
MsSqlTestHelper.GetTestConnectionString(TestContext.CurrentContext.Test.FullName),
tableNameResolver ?? new DefaultTableNameResolver(),
columnNameResolver ?? new DefaultColumnNameResolver()));
}
else if (IsMySql(dataContextType))
{
MySqlTestHelper.CreateTestDatabase(TestContext.CurrentContext.Test.FullName);
return(new MySqlDataContext(
MySqlTestHelper.GetTestConnectionString(TestContext.CurrentContext.Test.FullName),
tableNameResolver ?? new DefaultTableNameResolver(),
columnNameResolver ?? new DefaultColumnNameResolver()));
}
else if (IsSqlite(dataContextType))
{
SqliteTestHelper.CreateTestDatabase(TestContext.CurrentContext.Test.FullName);
return(new SqliteDataContext(
SqliteTestHelper.GetTestConnectionString(TestContext.CurrentContext.Test.FullName),
tableNameResolver ?? new DefaultTableNameResolver(),
columnNameResolver ?? new DefaultColumnNameResolver()));
}
else
{
throw new ArgumentException($"Type {dataContextType} is not supported, add support in {nameof(Helpers.DataContextTestHelper)}.cs");
}
}
/// <summary>
/// 设置表名解析器
/// </summary>
/// <param name="resolver">在请求表名格式时使用解析器</param>
public static void SetTableNameResolver(ITableNameResolver resolver)
{
_tableNameResolver = resolver;
}
protected SqlQueryBuilderBase(ITableNameResolver tableNameResolver, IColumnNameResolver columnNameResolver, IEnumerable <SqlClause> clauses = null)
{
TableNameResolver = tableNameResolver;
ColumnNameResolver = columnNameResolver;
_clauses = clauses?.ToList() ?? new List <SqlClause>();
}
public MsSQLQueryBuilder(ISQLTemplate template, ITableNameResolver tblresolver, IColumnNameResolver colresolver)
: base(template, tblresolver, colresolver)
{
}
