OrmLiteWriteExpressionsApiLegacy
Assembly: ServiceStack.OrmLite.dll
View Source
public static class OrmLiteWriteExpressionsApiLegacy : object
Methods
InsertOnly<T>(IDbConnection, T, Func<SqlExpression<T>, SqlExpression<T>>)
Insert only fields in POCO specified by the SqlExpression lambda. E.g: <p>db.InsertOnly(new Person { FirstName = "Amy", Age = 27 }, q => q.Insert(p => new { p.FirstName, p.Age }))</p>
View Source
public static void InsertOnly<T>(this IDbConnection dbConn, T obj, Func<SqlExpression<T>, SqlExpression<T>> onlyFields)
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
<T> | obj |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | onlyFields |
Type Parameters
T
UpdateOnly<T>(IDbConnection, T, Func<SqlExpression<T>, SqlExpression<T>>)
Use an SqlExpression to select which fields to update and construct the where expression, E.g:
db.UpdateOnly(new Person { FirstName = "JJ" }, ev => ev.Update(p => p.FirstName).Where(x => x.FirstName == "Jimi")); UPDATE "Person" SET "FirstName" = 'JJ' WHERE ("FirstName" = 'Jimi')
What's not in the update expression doesn't get updated. No where expression updates all rows. E.g:
db.UpdateOnly(new Person { FirstName = "JJ", LastName = "Hendo" }, ev => ev.Update(p => p.FirstName)); UPDATE "Person" SET "FirstName" = 'JJ'
View Source
public static int UpdateOnly<T>(this IDbConnection dbConn, T model, Func<SqlExpression<T>, SqlExpression<T>> onlyFields)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
<T> | model |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | onlyFields |
Type Parameters
T
UpdateFmt<T>(IDbConnection, String, String)
Flexible Update method to succinctly execute a free-text update statement using optional params. E.g:
db.Update<Person>(set:"FirstName = {0}".Params("JJ"), where:"LastName = {0}".Params("Hendrix")); UPDATE "Person" SET FirstName = 'JJ' WHERE LastName = 'Hendrix'
View Source
public static int UpdateFmt<T>(this IDbConnection dbConn, string set = null, string where = null)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
System.String | set |
System.String | where |
Type Parameters
T
UpdateFmt(IDbConnection, String, String, String)
Flexible Update method to succinctly execute a free-text update statement using optional params. E.g.
db.Update(table:"Person", set: "FirstName = {0}".Params("JJ"), where: "LastName = {0}".Params("Hendrix")); UPDATE "Person" SET FirstName = 'JJ' WHERE LastName = 'Hendrix'
View Source
public static int UpdateFmt(this IDbConnection dbConn, string table = null, string set = null, string where = null)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
System.String | table |
System.String | set |
System.String | where |
DeleteFmt<T>(IDbConnection, String)
Flexible Delete method to succinctly execute a delete statement using free-text where expression. E.g.
db.Delete<Person>(where:"Age = {0}".Params(27)); DELETE FROM "Person" WHERE Age = 27
View Source
public static int DeleteFmt<T>(this IDbConnection dbConn, string where = null)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
System.String | where |
Type Parameters
T
DeleteFmt(IDbConnection, String, String)
Flexible Delete method to succinctly execute a delete statement using free-text where expression. E.g.
db.Delete(table:"Person", where: "Age = {0}".Params(27)); DELETE FROM "Person" WHERE Age = 27
View Source
public static int DeleteFmt(this IDbConnection dbConn, string table = null, string where = null)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
System.String | table |
System.String | where |
Delete<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>)
Delete the rows that matches the where expression, e.g:
db.Delete<Person>(ev => ev.Where(p => p.Age == 27)); DELETE FROM "Person" WHERE ("Age" = 27)
View Source
public static int Delete<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> where)
Returns
System.Int32
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | where |
Type Parameters
T
InsertOnly<T>(IDbConnection, T, SqlExpression<T>)
Using an SqlExpression to only Insert the fields specified, e.g:
db.InsertOnly(new Person { FirstName = "Amy" }, q => q.Insert(p => new { p.FirstName })); INSERT INTO "Person" ("FirstName") VALUES ('Amy');
View Source
public static void InsertOnly<T>(this IDbConnection dbConn, T obj, SqlExpression<T> onlyFields)
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
<T> | obj |
ServiceStack.OrmLite.SqlExpression<T> | onlyFields |
Type Parameters
T