SqlQuery 类

命名空间

ShadowSql.Queries

程序集

ShadowSql.Core.dll

Sql查询基类

public abstract class SqlQuery : ISqlLogic, ISqlFragment

继承

object

SqlQuery

实现

ISqlLogic

ISqlFragment

Derived

SqlAndQuery

SqlOrQuery

继承成员

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

构造函数

SqlQuery(ComplexLogicBase, SqlConditionLogic)

Sql查询基类

protected SqlQuery(ComplexLogicBase complex, SqlConditionLogic conditions)

参数

complex ComplexLogicBase

conditions SqlConditionLogic

字段

_conditions

Sql查询条件

protected readonly SqlConditionLogic _conditions

字段值

SqlConditionLogic

属性

Conditions

Sql查询条件

public SqlConditionLogic Conditions { get; }

属性值

SqlConditionLogic

方法

And(AtomicLogic)

And查询

public virtual SqlAndQuery And(AtomicLogic atomic)

参数

atomic AtomicLogic

返回

SqlAndQuery

And(params IEnumerable<string>)

And查询

public virtual SqlAndQuery And(params IEnumerable<string> conditions)

参数

conditions IEnumerable<string>

返回

SqlAndQuery

CopyQuery()

复制查询

public abstract SqlQuery CopyQuery()

返回

SqlQuery

CreateAndQuery()

构造查询

public static SqlAndQuery CreateAndQuery()

返回

SqlAndQuery

示例

var query = SqlQuery.CreateAndQuery("Id=@Id", "Status=@Status");

CreateOrQuery()

构造Or查询

public static SqlOrQuery CreateOrQuery()

返回

SqlOrQuery

示例

var query = SqlQuery.CreateOrQuery("Id=@Id", "Status=@Status");

Or(AtomicLogic)

Or查询

public virtual SqlOrQuery Or(AtomicLogic atomic)

参数

atomic AtomicLogic

返回

SqlOrQuery

Or(params IEnumerable<string>)

Or查询

public virtual SqlOrQuery Or(params IEnumerable<string> conditions)

参数

conditions IEnumerable<string>

返回

SqlOrQuery

ToAnd()

And查询

public abstract SqlAndQuery ToAnd()

返回

SqlAndQuery

ToOr()

Or查询

public abstract SqlOrQuery ToOr()

返回

SqlOrQuery

TryWrite(ISqlEngine, StringBuilder)

拼写sql

public bool TryWrite(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

返回

bool