Gentle.net Framework 入门二（基础示例）

 1． 一个基本的示例

通过该示例可以撑握以下内容：

1)     Gentle.net是怎么把对象（类）和关系数据库(SQL)关联起来的.

2)     使用Gentle.net插入，更新，返回实例信息，和删除数据.

本示例中以人为实例，包括人ID和姓名.附上建表脚本

示例表代码
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Peoples]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Peoples]
GO

CREATE TABLE [dbo].[Peoples] (
    [PeopleID] [int] IDENTITY (1, 1) NOT NULL ,
    [PeopleName] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

接着附上代码，相关使用请看代码。

示例代码
using System;
using Gentle.Framework;

namespace ConGentleStudy
{
    /**//// <summary>
    /// BaseExample 的摘要说明。
    /// </summary>
    public class BaseExample
    {
        [STAThread]
        static void Main(string[] args)
        {
                Console.WriteLine("创建人实例。");
            Peoples people=new Peoples("xuanfeng"); 
                Console.WriteLine("创建人实例。");
            Broker.Insert(people);
                Console.WriteLine("创建人实例。");
            people.PeopleName="peizunyou";
                Console.WriteLine("更新人的信息。");
            Broker.Update(people);
                Console.WriteLine("创建返回实例信息的Key!");
            Key key=new Key("Peoples",typeof(Peoples),true,"PeopleName","peizunyou");
            Console.WriteLine(key.Count.ToString());
        
                Console.WriteLine("创建人实例！");
            Peoples people1=new Peoples();//必须先实例化申请到空间，下步才不会出错。
            people1.PeopleName="xiamfe";
                Console.WriteLine("返回一个人实例的信息！");
            // Peoples people1=(Peoples)Broker.RetrieveInstance(typeof(Peoples),key),这样是将出错
            people1=(Peoples)Broker.RetrieveInstance(typeof(Peoples),key) ;//返回一个实例信息。 
                Console.WriteLine("输出人的姓名");
            Console.WriteLine(people1.PeopleName);
                Console.WriteLine("删除信息！");
             Key key_rem=new Key(typeof(Peoples),true,"PeopleID",people1.PeopleID);
             Broker.Remove(typeof(Peoples),key_rem);//主意，Key中提供的字段PeopleID是表中的主键，删除才有效！
            
                Console.WriteLine("演示完成,按任何键退出!");
                Console.Read();
        
        }
        
    }

    
    [TableName("Peoples") ]
    public class Peoples
    {    
        string name;
        int id;
        public Peoples(int _id,string _name)
        {
            this.name=_name;
            this.id=_id;
        }
        public Peoples(string _name)
        {
            this.name=_name;
        }
        public Peoples()
        {
            
        }
        [TableColumn("PeopleID",true),PrimaryKey(AutoGenerated=true)]
        public int PeopleID
        {
            get{return    this.id    ;}
            set{this.id=value;}
        }
        [TableColumn("PeopleName",true)]
        public string PeopleName
        {
            get{return this.name;}
            set{this.name=value;}
        }
        
    }
}