Smark.Data Part1

       这一章主要介绍一下如何使用Smark.Data组件进行数据库操作；让使用者了简单了解一下Smark.Data的配置、实体类配置和简单的操作。在使用组件时程序必须引用Smark.Core和Smark.Data两个组件；其源代码可以到：http://smark.codeplex.com/下载。为了方便范例所使用的数据是Northwind.mdb.

l        配置文件设置:

  <configSections>

    <section  name="smarkdata" type="Smark.Data.SmarkDataSection,Smark.Data"/>

  </configSections>

  <smarkdata>

    <Connection>

      <add name="0" type="Smark.Data.MSAccess,Smark.Data" connectionstring=""/>

    </Connection>

    <Assembly>

      <add type="Smark.Samples.Entities"/>

    </Assembly>

</smarkdata>

l        实体类创建

实体类是通过自定义工具，把相关接口代码生成类代码；所以必须安装Smark.Data.InterfaceToModelGenerator。

创建Entities.cs文件->文件属性的：InterfaceToModel

    [Table("Employees")]

    interface IEmployee

    {

        [ID]

        [IDENTITY]

        int EmployeeID { get; set; }

        [Column]

        string LastName { get; set; }

        [Column]

        string FirstName { get; set; }

        [Column]

        string Title { get; set; }

        [Column]

        string TitleOfCourtesy { get; set; }

        [Column]

        DateTime BirthDate { get; set; }

        [Column]

        DateTime HireDate { get; set; }

        [Column]

        string Address { get; set; }

        [Column]

        string City { get; set; }

        [Column]

        string Region { get; set; }

        [Column]

        string PostalCode { get; set; }

        [Column]

        string Country { get; set; }

        [Column]

        string HomePhone { get; set; }

        [Column]

        string Extension { get; set; }

        [Column]

        string Photo { get; set; }

        [Column]

        string Notes { get; set; }

        [Column]

        int ReportsTo { get; set; }

 }

InterfaceToModelGenerator会根据接口文件生成实体文件

    [Table("Employees")]

     [Serializable]

    public partial class Employee:Smark.Data.Mappings.DataObject,IEmployee

    {

        [ID]

        [IDENTITY]

        public int EmployeeID { get{ return mEmployeeID;} set{mEmployeeID=value;EntityState.FieldChange("EmployeeID");} }

 

         private int mEmployeeID;

 

         public static Smark.Data.FieldInfo employeeID = new Smark.Data.FieldInfo("Employees","EmployeeID");

 

        [Column]

        public string LastName { get{ return mLastName;} set{mLastName=value;EntityState.FieldChange("LastName");} }

 

         private string mLastName;

 

         public static Smark.Data.FieldInfo lastName = new Smark.Data.FieldInfo("Employees","LastName");

 

        [Column]

        public string FirstName { get{ return mFirstName;} set{mFirstName=value;EntityState.FieldChange("FirstName");} }

 

         private string mFirstName;

 

         public static Smark.Data.FieldInfo firstName = new Smark.Data.FieldInfo("Employees","FirstName");

 

        [Column]

        public string Title { get{ return mTitle;} set{mTitle=value;EntityState.FieldChange("Title");} }

 

         private string mTitle;

 

         public static Smark.Data.FieldInfo title = new Smark.Data.FieldInfo("Employees","Title");

 

        [Column]

        public string TitleOfCourtesy { get{ return mTitleOfCourtesy;} set{mTitleOfCourtesy=value;EntityState.FieldChange("TitleOfCourtesy");} }

 

         private string mTitleOfCourtesy;

 

         public static Smark.Data.FieldInfo titleOfCourtesy = new Smark.Data.FieldInfo("Employees","TitleOfCourtesy");

l        数据库操作

            DBContext.SetConnectionString(ConnectionType.Context1, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.cnblogs.com/Northwind.mdb");

            Employee emp = DBContext.Load<Employee>(3);

            Console.WriteLine(emp.FirstName + "\t" + emp.LastName);

            Console.WriteLine(emp.Country);

 

 

            emp.Country = emp.Country + "Change";

            DBContext.Save(emp);

 

 

            emp = new Employee();

            emp.FirstName = "henry";

            emp.LastName = "Fan";

            DBContext.Save(emp);

 

范例详细代码：

http://smark.codeplex.com/源代码的Samples目录下。