Skip to main content

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
TypeName
System.Stringsql
System.Objectparameters

LeftJoin(String, Object)

View Source
Declaration
public SqlBuilder LeftJoin(string sql, object parameters = null)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Stringsql
System.Objectparameters

Where(String, Object)

View Source
Declaration
public SqlBuilder Where(string sql, object parameters = null)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Stringsql
System.Objectparameters

OrderBy(String, Object)

View Source
Declaration
public SqlBuilder OrderBy(string sql, object parameters = null)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Stringsql
System.Objectparameters

Select(String, Object)

View Source
Declaration
public SqlBuilder Select(string sql, object parameters = null)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Stringsql
System.Objectparameters

AddParameters(Object)

View Source
Declaration
public SqlBuilder AddParameters(object parameters)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Objectparameters

Join(String, Object)

View Source
Declaration
public SqlBuilder Join(string sql, object parameters = null)
Returns

ServiceStack.OrmLite.SqlBuilder

Parameters
TypeName
System.Stringsql
System.Objectparameters