MicroOrm.Net(3)数据库、表、列、表达式、MathMathE

2023-09-16 13:42:01 墨初知识笔记 103阅读

MicroOrm.Net首页：MicroOrm.Net系列休闲目录概述：在开始详细讲解MicroOrm.Net的使用之前，我们先来了解一下MicroOrm中的几个动态对象。网络：

font-family: verdana, Arial, Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; orphans: 2; text-transform: none; white-space: normal; widows: 2; word-spacing: 0">Database：数据库对象，我们在后面再详细讲解。

Table：下面代码中db.OrderDetail就是一个Table对象，它和数据库里的OrderDetail相对应

var od = db.OrderDetail;

Column：下面代码中db.OrderDetail.ProductId就是一个Column对象，它和数据库里的OrderDetail表里的ProductId列对应

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

Expression：下面代码中db.OrderDetail.OrderId == "001"就是一个Expression对象

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

Math&MathE：

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

下面是这几个对象的api说明：

//Database
Database Open(string connectionStringName)
CodeScope BeginCodeScope()
Transaction BeginTransactionScope()
Table xxx
//Table
Query 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)
//Expression
Expression(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)
//Math
Math(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)
//MathE
MathE As(string alias)

标签：