SqlBuilder
Nice SqlBuilder class by @samsaffron from Dapper.Contrib: http://samsaffron.com/archive/2011/09/05/Digging+ourselves+out+of+the+mess+Linq-2-SQL+created Modified to work in .NET 3.5
Assembly: ServiceStack.OrmLite.dll
View Source
Declaration
public class SqlBuilder : object
Methods
AddTemplate(String, Object)
View Source
Declaration
public SqlBuilder.Template AddTemplate(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder.Template
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |
LeftJoin(String, Object)
View Source
Declaration
public SqlBuilder LeftJoin(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |
Where(String, Object)
View Source
Declaration
public SqlBuilder Where(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |
OrderBy(String, Object)
View Source
Declaration
public SqlBuilder OrderBy(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |
Select(String, Object)
View Source
Declaration
public SqlBuilder Select(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |
AddParameters(Object)
View Source
Declaration
public SqlBuilder AddParameters(object parameters)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.Object | parameters |
Join(String, Object)
View Source
Declaration
public SqlBuilder Join(string sql, object parameters = null)
Returns
ServiceStack.OrmLite.SqlBuilder
Parameters
Type | Name |
---|---|
System.String | sql |
System.Object | parameters |