namespace ORM

 {

     class Program

     {

         static void Main(string[] args)

         {

             //AddPetStore();//添加

             UpdatePetStore();//修改

         }

         /// <summary>

         /// 添加

         /// </summary>

         private static void AddPetStore()

         {

             PetStore store = new PetStore()

             {

                 Name = "张三",

                 PassWord = "",

                 Balance =

             };

             using (CIM_CWEntities entities = new CIM_CWEntities())

             {

                 entities.PetStore.Add(store);

                 if (entities.SaveChanges() > )

                 {

                     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 = "";

                 }

                 if (entities.SaveChanges() > )

                 {

                     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[].Name = "李四";

                 list[].PassWord = "";

                 if (entities.SaveChanges() > )

                 {

                     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() > )

                 {

                     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 > )

                 {

                     Console.WriteLine("添加成功...");

                 }

             }

         }

         private static void ExecuteScalar()

         {

             int obj = ;

             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",),

                     new SqlParameter ("@count",System.Data.SqlDbType.Int)//输出参数int

                 };

                 sqls[].Direction = ParameterDirection.Output;

                 List<PetStore> stores = entities.Database.SqlQuery<PetStore>("proc_GetPetStore @typeId,@count output",sqls).ToList();

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

             }

         }

     }

 }