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' ";