初识OR Mapping

公司数据库模块的操作

1.登入sqlserver连接到服务器，创建你需要的数据库

2.进入“//server/project”，建立一个属于你自己的文件夹（方便让UI访问）

3.进入“http://server/mango/”，单击你自己的数据库，选择你要生成的路径，单击生成按钮

4.打开VS，创建一个类库，选中项目，右击，选择“属性”，在弹出的窗体中，选择“生成”，在输出路径中填入你要生成到的位置（应生成到服务器上。选中XML文档文件按钮）

5.添加引用，把原先数据库生成的DLL文件引用进来

好，现在我们就可以编写类了。以下是简单的增删改查实例，希望可以给公司新进来的学数据库的同事有所帮助

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Test.Data;
using Test.Entities;
using System.Data;

namespace Tt{
    /// <summary>
    /// 订单类
    /// </summary>
    public class OrderService
    {
        /// <summary>
        /// 添加一个客户信息
        /// </summary>
        /// <param name="name">客户名</param>
        public void AddCus(string name)
        {
            Customer cus = new Customer();
            cus.FName = name;
            DataRepository.CustomerProvider.Insert(cus);
        }

        //直接传入对象直接使用即可

        /// <summary>
        /// 根据Id查询
        /// </summary>
        /// <param name="customerId"></param>
        /// <returns></returns>
        public Customer Find(long customerId)
        {
            return  DataRepository.CustomerProvider.GetByFCustomerID(customerId);
        }

        /// <summary>
        /// 根据name查询客户信息
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public TList<Customer> Find(string name)
        {
            CustomerQuery cu = new CustomerQuery();
            cu.Append(CustomerColumn.FName, name);
            return DataRepository.CustomerProvider.Find(cu);
        }

      
        /// <summary>
        ///根据name删除
        /// </summary>
        /// <param name="name"></param>
        public void del(string name)
        {          
            CustomerQuery cu = new CustomerQuery();
            cu.Append(CustomerColumn.FName, name);
            TList<Customer> t = DataRepository.CustomerProvider.Find(cu);
            DataRepository.CustomerProvider.Update(t);
        }

        /// <summary>
        /// 把第一个名为大王的字段改成name
        /// </summary>
        /// <param name="name"></param>
        public void Set(string name)
        {
            CustomerQuery customerQuery = new CustomerQuery();
            customerQuery.Append(CustomerColumn.FName, "大王");

            TList<Customer> newCustomer = DataRepository.CustomerProvider.Find(customerQuery);
            修改记录
            newCustomer[0].FName = name;           
            DataRepository.CustomerProvider.Update(newCustomer[0]);
        }

        /// <summary>
        /// 根据Id把FName的值更改为name
        /// </summary>
        /// <param name="id"></param>
        /// <param name="name"></param>
        public void Set(long id,string name)
        {
           Customer newCustomer = DataRepository.CustomerProvider.GetByFCustomerID(id);
            修改记录
           newCustomer.FName = name;
           DataRepository.CustomerProvider.Update(newCustomer);
        }

        /// <summary>
        /// 深度更新
        /// </summary>
        /// <param name="id"></param>
        /// <param name="name"></param>
        public void Set(long id, string name)
        {
            Order order = new Order();
            order.FCustomerId = 1;
            order.FCount = 2;
            Customer newCustomer = DataRepository.CustomerProvider.GetByFCustomerID(id);
            TList<OrderDetail> tlistOrderDetail = new TList<OrderDetail>();
            //第一个订单详细
            OrderDetail orderdetail = new OrderDetail();
            orderdetail.FName = "相机";
            orderdetail.ForderId = order.FOrdersId;
            tlistOrderDetail.Add(orderdetail);
            //第二个订单详细
            OrderDetail orderdetail1 = new OrderDetail();
            orderdetail1.FName = "电脑";
            tlistOrderDetail.Add(orderdetail1);
            orderdetail1.FOrderDetailId = order.FOrdersId;
            //OrderDetailCollection订单详细集合
            order.OrderDetailCollection = tlistOrderDetail;
            DataRepository.OrderProvider.DeepSave(order);
        }
        
        
    }
}