记录Castle ActiveRecord访问Sqlite的配置

1、ActiveRecord配置文件ARConfig.xml，并将配置文件的“生成操作”改成“嵌入的资源”

<?xml version="1.0" encoding="utf-8" ?>
<activerecord isWeb="true">
  <config>
    <add key="connection.driver_class" value="NHibernate.Driver.SQLite20Driver" />
    <add key="dialect" value="NHibernate.Dialect.SQLiteDialect" />
    <add key="connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
    <add key="connection.connection_string" value="data source=|DataDirectory|\message.db;Version=3;" />
    <add key="proxyfactory.factory_class" value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"/>
    <add key="show_sql" value="true"/>
  </config>
</activerecord>

2、使用到的DLL文件

3、测试实体类UserInfo

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Castle.ActiveRecord;
using NHibernate;

namespace CY.Domain
{
    [ActiveRecord("T_User")]
    public class UserInfo : ActiveRecordBase
    {
        #region 属性

        [PrimaryKey(PrimaryKeyType.Identity, "ID")]
        public int ID { get; set; }

        [Property("UserName")]
        public string Name { get; set; }

        [Property("Password")]
        public string Password { get; set; }

        [Property("RegTime")]
        public DateTime RegTime { get; set; }

        #endregion

        #region 方法

        public static void Insert(UserInfo user)
        {
            Save(user);
        }

        public static IList<UserInfo> Select()
        {
            return (IList<UserInfo>)FindAll(typeof(UserInfo));
        }

        public static UserInfo Query(int id)
        {
            object model = FindByPrimaryKey(typeof(UserInfo), id);

            return model != null ? model as UserInfo : null;
        }

        public static void Del(int id)
        {
            UserInfo model = Query(id);
            if (model != null)
            {
                Delete(model);
            }
        }
       
        #endregion
    }
}

4、初始化实体类对象（Global.asax）

using Castle.ActiveRecord;

using Castle.ActiveRecord.Framework.Config;

        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();

            RegisterRoutes(RouteTable.Routes);

            XmlConfigurationSource source = new XmlConfigurationSource(Server.MapPath("ARConfig.xml"));
            ActiveRecordStarter.Initialize(source, typeof(UserInfo));
        }

 

5、使用

            for (int i = 0; i < 10; i++)
            {
                UserInfo.Insert(new UserInfo()
                {
                    Name = "user" + i.ToString(),
                    Password = "123456",
                    RegTime = DateTime.Now
                });
            }

            IList<UserInfo> models = UserInfo.Select();
            ViewData["users"] = models;