ORM简单增删改查

namespace ORM
{
    class Program
    {
        static void Main(string[] args)
        {
            //AddPetStore();//添加
            UpdatePetStore(1);//修改
        }
        /// <summary>
        /// 添加
        /// </summary>
        private static void AddPetStore()
        {
            PetStore store = new PetStore()
            {
                Name = "张三",
                PassWord = "123",
                Balance = 1
            };
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                entities.PetStore.Add(store);
                if (entities.SaveChanges() > 0)
                {
                    Console.WriteLine("添加-成功");
                }
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="storeId"></param>
        private static void UpdatePetStore(int storeId)
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                //第一种修改
                //PetStore store = entities.PetStore.FirstOrDefault(i => i.Id == storeId);//lambda表达式：用于简化委托和实例
                //store.Name = "李四1";
                //store.PassWord = "456";

                //第二种修改
                IQueryable<PetStore> store = entities.PetStore.Where(i => i.Id == storeId);//可以根据多条件修改
                foreach (var item in store)
                {
                    item.Name = "王维";
                    item.PassWord = "456789";
                }
                if (entities.SaveChanges() > 0)
                {
                    Console.WriteLine("修改成功....");
                }
            }
        }
        /// <summary>
        /// 批量修改成功
        /// </summary>
        /// <param name="typeId"></param>
        private static void EditPetStore(int typeId)
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                var list = entities.PetStore.Where<PetStore>(i => i.Id == typeId).OrderByDescending(p => p.Id).ToList<PetStore>();
                list[0].Name = "李四";
                list[1].PassWord = "456123";
                if (entities.SaveChanges() > 0)
                {
                    Console.WriteLine("批量修改成功...");
                }
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="storeid"></param>
        private static void RemovePetSotre(int storeid)
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                PetStore petStore = entities.PetStore.Single<PetStore>(i => i.Id == storeid);
                entities.PetStore.Remove(petStore);
                if (entities.SaveChanges() > 0)
                {
                    Console.WriteLine("删除成功...");
                }
            }
        }
        /// <summary>
        /// linq查询
        /// </summary>
        private static void GetPetSotre()
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                var pr = from a in entities.PetStore
                         join b in entities.Pet
                         on a.Id equals b.Store_Id
                         select new { a.Name, b.Love };
                foreach (var item in pr)
                {
                    Console.WriteLine($"名称：{item.Name}-爱好：{item.Love}");
                }
            }
        }
        /// <summary>
        /// 添加方法
        /// </summary>
        /// <param name="pet"></param>
        private static void ExecuteNonQuery(PetStore pet)
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                SqlParameter[] sqls = {
                    new SqlParameter("@name",pet.Name),
                    new SqlParameter ("@pwd",pet.PassWord),
                    new SqlParameter ("@banl",pet.Balance)
                };
                int result = entities.Database.ExecuteSqlCommand("insert into PetStore(Name,PassWord,Balance) values(@name,@pwd,@banl)", sqls);
                if (result > 0)
                {
                    Console.WriteLine("添加成功...");
                }
            }
        }
        private static void ExecuteScalar()
        {
            int obj = 0;
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                obj = entities.Database.SqlQuery<int>("select count(1) from PetStore").Single();//SQL所有查询，存储过程调用
            }
        }
        private static void ExecuteReader()
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                List<PetStore> store = entities.Database.SqlQuery<PetStore>("select * from PetStore").ToList();
            }
        }
        private static void ExecuteProc()
        {
            using (CIM_CWEntities entities = new CIM_CWEntities())
            {
                SqlParameter[] sqls =
                    {
                    new SqlParameter ("@typeId",1),
                    new SqlParameter ("@count",System.Data.SqlDbType.Int)//输出参数int
                };
                sqls[1].Direction = ParameterDirection.Output;
                List<PetStore> stores = entities.Database.SqlQuery<PetStore>("proc_GetPetStore @typeId,@count output",sqls).ToList();

                int count =(int)sqls[1].Value;
            }
        }
    }
}