Grove操作

一：单个对象增、删、改、查

以下是用户对象实体类(EntityClass)定义

using System;using Grove.ORM;namespace DataEntity{ [DataTable("user")] public class user { private int _Id; [KeyField("Id")] public int Id { get { return _Id; } set { _Id = value; } } private string _name; [DataField("Name")] public string Name { get { return _name; } set { _name = value; } } }}

连接字符串：string connectionStr = @"Data Source=PC-200901070944/;Initial Catalog=test;Integrated Security=True";

 添加记录：

Grove.ORM.ObjectOperator oper = new Grove.ORM.ObjectOperator(connectionStr);
int i= oper.Insert(us);

删除记录：

ObjectOperator oper = new ObjectOperator(connectionStr);
int i = oper.Remove(typeof(user), string.Format(" Name='{0}'", "aaa")

string sql=" delete from [user] where Name='aaa' ";

修改记录：

ObjectOperator oper = new ObjectOperator(connectionStr);
int i= oper.Update(us);

查询记录：

 user us= oper.Retrieve(typeof(user),22) as user;

->User 表主键=22

相当于string sql=" select * from [user] where Id=22 ";

 

二：多表查询：

以下式用户详细信息实体类(EntityClass)定义

using System;using Grove.ORM;namespace DataEntity{ [Grove.ORM.DataTable("Detail")] public class Detail { private int _id; [Grove.ORM.KeyField("Id")] public int Id { get { return _id; } set { _id = value; } } private int _userId; [Grove.ORM.ForeignKeyField("Id")] public int UserId { get { return _userId; } set { _userId = value; } } private string _email; [Grove.ORM.BaseField("Email")] public string Email { get { return _email; } set { _email = value; } } }}

 

通过一个关系类实现多表查询

以下是关系实体类定义

namespace DataEntity{using System;using Grove.ORM;[RelationTable("DetailRelationQuery",BeginWithTable="Detail")]public class DetailRelationQuery{[RelationReflect("Detail","user")][RelationField("UserId","Id")]public string Relationship_1{get{return "[Detail].[UserId]=[user].[Id]";}}String _Email;[DataField("Email",TableName="Detail")]public String Email{get{return this._Email;}set{this._Email=value;}}Int32 _UserId;[DataField("UserId",TableName="Detail")]public Int32 UserId{get{return this._UserId;}set{this._UserId=value;}}}}

执行查询语句：

ObjectOperator OO= new ObjectOperator(connectionStr);

ObjectQuery OQ = new ObjectQuery(typeof(DetailRelationQuery), " Name='chunfeng'");
DetailRelationQuery UserDetail= OO.GetObjectSet(OQ )[0] as DetailRelationQuery;

相当于执行

string sql="SELECT  [Detail].[Email],[Detail].[UserId] FROM [Detail] INNER JOIN [user] ON [Detail].[UserId] = [user].[Id] WHERE  [User].Name='chunfeng' ";

既:

string sql="SELECT  [Detail].[Email],[Detail].[UserId] FROM [Detail] ,[user] Where [Detail].[UserId] = [user].[Id] and [User].Name='chunfeng' ";