利用Grove Tool Kit 连接NorthWind 并生成Customers、Orders、Employees实体类
1、ObjectOperator
//实例化ObjectOperator类
string conn=System.Configuration.ConfigurationSettings.AppSettings["strconnection"];
Grove.ORM.ObjectOperator obj=new ObjectOperator(conn);
| Method | Description |
| Insert | Insert an object into the data source |
| Update | Update an object |
| Remove | Delete an object from the data source |
| RemoveChilds | Delete child objects |
| Retrieve | Returns an object from the data source |
| RetrieveChilds | Returns child objects from the data source |
| GetDataReader | Returns an IDataReader from the data source |
| GetObjectSet | Returns a collection of object values |
| GetObjectSource | Returns a DataSet which contain the data source of the object |
| GetCount | Returns a records count of the data source |
| BeginTranscation | Begins a transaction at the data source, if transactions are supported by the data source. |
| Commit | Commits the current transaction. |
| Rollback | Rolls back the current transaction. |
2、ObjectQuery 类
//实例化ObjectQuery ,返回对象的所有记录集
ObjectQuery query = new ObjectQuery (typeof(Customer),"");
3、返回DataSet 数据集
Grove.ORM.ObjectOperator obj=new ObjectOperator(conn);
Grove.ORM.ObjectQuery query = new ObjectQuery (typeof(Customers),"");
DataSet ds = obj.GetObjectSource(query);
4、返回ArrayList集合
Grove.ORM.ObjectOperator obj=new ObjectOperator(conn);
Grove.ORM.ObjectQuery query = new ObjectQuery (typeof(Customers),"");
ArrayList al = obj.GetObjectSet(query);
5、返回IDataReader
Grove.ORM.ObjectOperator obj=new ObjectOperator(conn);
Grove.ORM.ObjectQuery query = new ObjectQuery (typeof(Customers),"");
IDataReader dr = obj.GetDataReader(query);
