Microorm. Net (3) database, table, column, expression, math & mathe

Microorm. Net homepage:

Http://code.google.com/p/micro-orm-net/

Overview of the microorm. Net series directories:

Http://www.cnblogs.com/mapserver/archive/2012/04/07/2436129.html

 

Before using microorm. Net in detail, we should first understand several dynamic objects in microorm. Net:

Database: database object. We will explain it in detail later.

Table: In the following code, DB. orderdetail is a table object, which corresponds to orderdetail in the database.

var od = db.OrderDetail;

 

Column: In the following code, DB. orderdetail. productid is a column object, which corresponds to the productid column in The orderdetail table in the database.

var q = db.OrderDetail.Query()        .Select(db.OrderDetail.ProductId);

 

Expression: In the following code, DB. orderdetail. orderid = "001" is an expression object.

var q = db.OrderDetail.Query()        .Where(db.OrderDetail.OrderId == "001");

 

Math & mathe:

var q = db.OrderDetail.Query()        .Select(db.OrderDetail.OrderId + "_Order");

 

The following describes the APIs of these objects:

//DatabaseDatabase Open(string connectionStringName)CodeScope BeginCodeScope()Transaction BeginTransactionScope()Table xxx//TableQuery Query()int Insert(Anonymous type object)int Insert(Model object)int Insert(IDictionary dict)int Insert(named arguments)int Update(Anonymous type object)int Update(Model object)int Update(IDictionary dict)int Update(named arguments)int Update(Expression criteria, Anonymous type object)int Update(Expression criteria, Model object)int Update(Expression criteria, IDictionary dict)int Update(Expression criteria, Named arguments)int Delete(Anonymous type object)int Delete(Model object)int Delete(IDictionary dict)int Delete(named arguments)int Delete(Expression criteria)//ExpressionExpression(object left, object right, ExpressionOperator @operator)static Expression operator ==(Expression left, Expression right)static Expression operator !=(Expression left, Expression right)static Expression operator <(Expression left, Expression right)static Expression operator <=(Expression left, Expression right)static Expression operator >(Expression left, Expression right)static Expression operator >=(Expression left, Expression right)static Expression operator &(Expression left, Expression right) static Expression operator |(Expression left, Expression right)static bool operator true(Expression e)static bool operator false(Expression e)//MathMath(object left, object right, MathOperator @operator)static Math operator +(Math column, object value)static Math operator -(Math column, object value)static Math operator *(Math column, object value)static Math operator /(Math column, object value)//MathEMathE As(string alias)