public ExpressionSqlGenerator(IDbProviderExpressions provider, ITableInfoFactory factory, IEscapeIdentifier escape, ParametersManager param = null)
{
_sb = new StringBuilder();
_provider = provider;
_factory = factory;
_escape = escape;
Parameters = param ?? new ParametersManager();
}
public ExpressionSqlGenerator(IDbProviderExpressions provider, ITableInfoFactory factory, IEscapeIdentifier escape,ParametersManager param=null)
{
_sb = new StringBuilder();
_provider = provider;
_factory = factory;
_escape = escape;
Parameters = param ?? new ParametersManager();
}
public UpdateTableBuilder(IExecuteCustomSql executor, IGenerateSqlFromExpressions writer, IEscapeIdentifier utils, HelperOptions options)
{
_executor = executor;
_writer = writer;
_utils = utils;
_options = options;
_sb.Append($"update {utils.EscapeTableName(options.TableName)} set ");
}
public SqliteDbTools(IEscapeIdentifier utils)
{
_utils = utils;
}
public SqlServerDbTools(IEscapeIdentifier utils)
{
_utils = utils;
}
public string EscapeName(IEscapeIdentifier provider, TableName name = null)
{
name = name ?? TableName;
return(provider.EscapeTableName(name));
}
public SqliteDbTools(IEscapeIdentifier utils)
{
_utils = utils;
}
public SqlServerDbTools(IEscapeIdentifier utils)
{
_utils = utils;
}
public string EscapeName(IEscapeIdentifier provider,TableName name=null)
{
name = name ?? Table;
return provider.EscapeTableName(name);
}
public static string GetColumnName(this TableInfo info, string property, IEscapeIdentifier provider)
{
var col = info.Columns.First(d => d.PropertyInfo.Name == property);
return(provider.EscapeIdentifier(col.Name));
}
public static string GetColumnName(this TableInfo info, MemberExpression member, IEscapeIdentifier provider = null)
{
var col = info.Columns.First(d => d.PropertyInfo.Name == member.Member.Name);
return(provider?.EscapeIdentifier(col.Name) ?? col.Name);
}
