Entity Framework 使用体验

1. 使用 Entity Framework 框架+LINQ + SQL 2008 实现与数据库交互（业务类不需要写代码）,项目结构如下：

2. 添加数据库模型文件 TestSolutionDB.edmx

3. 业务类由TT 模板生成

 

4.实现数据为操作方法调用：

  public partial class edit : System.Web.UI.Page
    {
        IUserInfoDAO UserDao = Core.UnityService.GetService<IUserInfoDAO>();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Request.QueryString["id"] != null)
                {
                    string id = Request.QueryString["id"];
                    hidId.Value = id;
                    BindUserINfo();
                }
            }
        }

        /// <summary>
        ///  绑定信息
        /// </summary>
        private void BindUserINfo()
        {
            UserInfo user = UserDao.GetSingle(o => o.Id == hidId.Value);
            if (user != null)
            {
                txtUserCode.Text = user.UserCode;
                txtUserNameCn.Text = user.UserNamCn;
                txtEmail.Text = user.EmailAdd;
                txtPhone.Text = user.Phone;
            }
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, EventArgs e)
        {
            UserInfo user = UserDao.GetSingle(o => o.Id == hidId.Value);
            user.UserCode = txtUserCode.Text.Trim();
            user.EmailAdd = txtEmail.Text.Trim();
            user.Phone = txtPhone.Text.Trim();
            user.UserNamCn = txtUserNameCn.Text.Trim();
            int i = UserDao.Update(user);
            Response.Write("<script>alert('修改成功')</script>");
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button2_Click(object sender, EventArgs e)
        {
            UserInfo user = UserDao.GetSingle(o => o.Id == hidId.Value);
            int i= UserDao.Delete(user);
            Response.Write("<script>alert('删除成功')</script>");
        }
    }

 

5. 关键代码部分

 /// <summary>
    /// 服务容器
    /// </summary>
    public partial class UnityService
    {
        private static readonly string _Unity_Container_Name = "containers";

        /// <summary>
        /// 创建Unity Container
        /// </summary>
        /// <returns>IUnityContainer</returns>
        public static IUnityContainer CreateUnityContainer()
        {
            UnityConfigurationSection section = (UnityConfigurationSection)ConfigurationManager.GetSection("unity");
            IUnityContainer container = new UnityContainer().LoadConfiguration(section, _Unity_Container_Name);
            return container;
        }

        /// <summary>
        /// 获取实例
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <returns></returns>
        public static T GetService<T>()
        {
            try
            {
                T rev;
                object unityContainer = HttpContext.Current.Application["unityContainer"];
                //如果不存在
                if (unityContainer == null)
                {
                    unityContainer = CreateUnityContainer();
                    HttpContext.Current.Application["unityContainer"] = unityContainer;
                }
                IUnityContainer container = (UnityContainer)unityContainer;
                rev = container.Resolve<T>();
                return rev;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }

6.  web.config 文件配置映射

 <configSections>
    <section name="unity" type="Microsoft.Practices.Unity.Configuration.UnityConfigurationSection, Microsoft.Practices.Unity.Configuration, Version=2.1.505.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    
  </configSections>

 <!--Unity配置-->
  <unity xmlns="http://schemas.microsoft.com/practices/2010/unity">

    <assembly name="TestSolution.OA.BLL"/>
    <assembly name="TestSolution.OA.DAL"/>
    <assembly name="TestSolution.OA.Entities"/>
    <assembly name="TestSolution.OA.Utilities"/>
    <assembly name="TestSolution.OA.Core"/>


    <namespace name="TestSolution.OA.BLL"/>
    <namespace name="TestSolution.OA.DAL"/>
    <namespace name="TestSolution.OA.Entities"/>
    <namespace name="TestSolution.OA.Utilities"/>
    <namespace name="TestSolution.OA.Core"/>



    <container name="containers" >
      <!--数据访问组件 开始-->

      
      <register type="IUserInfoDAO" mapTo="UserInfoBO">
        <lifetime type="transient"/>
      </register>

      <!--数据访问组件 结束-->

    </container>
  </unity>

7. 修改 Global.asax.cs 文件 

 void Application_Start(object sender, EventArgs e)
        {
            // 在应用程序启动时运行的代码
            Application["unityContainer"] =Core.UnityService.CreateUnityContainer();
        }

        void Application_End(object sender, EventArgs e)
        {
            //  在应用程序关闭时运行的代码
            Application["unityContainer"] = null;

        }