惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

博客园 - 叶小钗
S
Security @ Cisco Blogs
月光博客
月光博客
V
Vulnerabilities – Threatpost
The Hacker News
The Hacker News
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Cisco Talos Blog
Cisco Talos Blog
J
Java Code Geeks
Scott Helme
Scott Helme
S
Schneier on Security
腾讯CDC
博客园 - 司徒正美
L
Lohrmann on Cybersecurity
Latest news
Latest news
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
有赞技术团队
有赞技术团队
AWS News Blog
AWS News Blog
V
Visual Studio Blog
D
Darknet – Hacking Tools, Hacker News & Cyber Security
Hugging Face - Blog
Hugging Face - Blog
爱范儿
爱范儿
小众软件
小众软件
博客园 - Franky
Attack and Defense Labs
Attack and Defense Labs
美团技术团队
IT之家
IT之家
TaoSecurity Blog
TaoSecurity Blog
SecWiki News
SecWiki News
P
Proofpoint News Feed
阮一峰的网络日志
阮一峰的网络日志
博客园_首页
PCI Perspectives
PCI Perspectives
量子位
T
Threat Research - Cisco Blogs
酷 壳 – CoolShell
酷 壳 – CoolShell
Last Week in AI
Last Week in AI
Cyberwarzone
Cyberwarzone
The Cloudflare Blog
博客园 - 三生石上(FineUI控件)
L
LINUX DO - 最新话题
Forbes - Security
Forbes - Security
罗磊的独立博客
宝玉的分享
宝玉的分享
Simon Willison's Weblog
Simon Willison's Weblog
雷峰网
雷峰网
www.infosecurity-magazine.com
www.infosecurity-magazine.com
人人都是产品经理
人人都是产品经理
N
News and Events Feed by Topic

博客园 - mapserver

MicroOrm.Net和现有ORM产品的对比 MicroOrm.Net(8) Table.Query() - Distinct、Skip & Take MicroOrm.Net(7) Table.Query() - Group By & Having MicroOrm.Net(6) Table.Query() - Join & Order By MicroOrm.Net(5) Table.Query() - Select MicroOrm.Net(4) Table.Query() - Where MicroOrm.Net(2) 基础及动态特性 MicroOrm.Net(1) 总览 Asp.net服务器控件编程(6) ViewState(二)——ViewState用法和IStateManager Asp.net服务器控件编程(5) 复杂属性 Asp.net服务器控件编程(4) 呈现 Asp.net服务器控件编程(3) ViewState(一)——asp.net控件的精华之一 Asp.net服务器控件编程(2) 来做个热身运动吧 Asp.net服务器控件编程(1) 开篇、基础 Asp.net服务器控件编程 总览 TextDataSource(3) — 请把我的数据更新回去 TextDataSource(2) — 翠花,上“数据” TextDataSource(1) — DataSourceControl内幕 .NET组件编程(10) 补充 ISupportInitialize
MicroOrm.Net(3) Database、Table、Column、Expression、Math&MathE
mapserver · 2012-04-08 · via 博客园 - mapserver

MicroOrm.Net主页:

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

MicroOrm.Net系列随便目录总览:

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

我们在开始详细讲解MicroOrm.Net的使用之前,先了解MicroOrm.Net里的几个动态对象:

Database:数据库对象,我们在后面再详细讲解。

Table:下面代码中db.OrderDetail就是一个Table对象,它和数据库里的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)