/// <summary>
/// Creates a new SQLinqInsert object for the specified Object and table name.
/// </summary>
/// <param name="data"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static SQLinqInsert <T> Insert <T>(T data, string tableName)
{
// initialize the Default ISqlDialect
var dialect = DialectProvider.Create();
return(Insert <T>(data, tableName, dialect));
}
/// <summary>
/// Creates a new DynamicSQLinq object for the specified table name.
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public static DynamicSQLinq Create(string tableName)
{
// initialize the Default ISqlDialect
var dialect = DialectProvider.Create();
return(Create(tableName, dialect));
}
/// <summary>
/// Creates a new SQLinq object for the Type of the object specified.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="obj">The object that defines the Type to use for creating the SQLinq object instance for.</param>
/// <returns></returns>
public static SQLinq <T> Create <T>(T obj, string tableName)
{
// initialize the Default ISqlDialect
var dialect = DialectProvider.Create();
return(Create <T>(obj, tableName, dialect));
}
/// <summary>
/// Creates a new SQLinqInsert object for the specified Object.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static SQLinqUpdate <T> Update <T>(T data)
{
// initialize the Default ISqlDialect
var dialect = DialectProvider.Create();
return(Update <T>(data, dialect));
}
public static SQLinqUpdate <T> ToSQLinqUpdate <T>(this T obj, string tableName = null, ISqlDialect dialect = null)
{
if (dialect == null)
{
dialect = DialectProvider.Create();
}
return(SQLinq.Update(obj, tableName, dialect));
}
/// <summary>
/// Creates a new DynamicSQLinqJoinExpression instance with the JoinOperator set to DynamicSQLinqJoinOperator.Inner ("INNER JOIN")
/// </summary>
/// <param name="tableName">The database Table / View to Join</param>
/// <param name="clause">The Join clause</param>
/// <param name="parameters">Any parameters necessary for the Join clause</param>
public DynamicSQLinqJoinExpression(string tableName, string clause, object[] parameters)
: this(DialectProvider.Create(), tableName, clause, parameters)
{
}
public DynamicSQLinqLambdaExpression(string fieldName, LambdaExpression expression)
: this(DialectProvider.Create(), fieldName, expression)
{
}
public SqlExpressionCompiler(int existingParameterCount = 0, string parameterNamePrefix = DefaultParameterNamePrefix)
: this(DialectProvider.Create(), existingParameterCount, parameterNamePrefix)
{
}
public DynamicSQLinqExpressionCollection(DynamicSQLinqWhereOperator whereOperator)
: this(DialectProvider.Create(), whereOperator)
{
}
public DynamicSQLinqExpressionCollection()
: this(DialectProvider.Create())
{
}
/// <summary>
/// Creates a new DynamicSQLinqSubQueryJoinExpression instance with the JoinOperator set to DynamicSQLinqJoinOperator.Inner ("INNER JOIN")
/// </summary>
/// <param name="query">The sub-query that will be joined</param>
/// <param name="alias">The Alias to give the sub-query within the main query</param>
/// <param name="clause">The Join clause</param>
/// <param name="parameters">Any parameters necessary for the Join clause</param>
public DynamicSQLinqSubQueryJoinExpression(ISQLinq query, string alias, string clause, params object[] parameters)
: this(DialectProvider.Create(), query, alias, DynamicSQLinqJoinOperator.Inner, clause, parameters)
{
}
public DynamicSQLinqInsert(IDictionary <string, object> data, string tableName)
: this(DialectProvider.Create(), data, tableName)
{
}
public DynamicSQLinq(string tableName)
: this(DialectProvider.Create(), tableName)
{
}
public DynamicSQLinqExpression(string clause, params object[] args)
: this(DialectProvider.Create(), clause, args)
{
}