subsonic增 删 改

save()---新增（并不会根据实体去判断是否有存在记录）

 

 

//这种更新方式没问题--------更新记录
            //Query q = new Query(Address.Schema);
            //q.AddUpdateSetting(Address.EmailColumn.ColumnName, "新加坡");
            //q.AddWhere(Address.CodeColumn.ColumnName, Comparison.Equals, "001");
            //q.AddWhere(Address.NoColumn.ColumnName, Comparison.NotEquals, "yang");

            //q.Execute();

            //-----------------------------------------

            //这种方式会新增一条新的记录, 并不会去判断是否有存在记录--新增
            Address add = new Address();
            add.Code = "001";
            add.No = "006";
            add.Email = "ex@mail.com";
            add.Save("joeyang"); // or add.Save();
            //------------------


            //这种方式也可行----更新记录
            //Query q = new UpdateQuery(Address.Schema)
            //.AddUpdateSetting(Address.EmailColumn.ColumnName, "dlkts@122222226.com");
            //q.AddWhere(Address.CodeColumn.ColumnName, Comparison.Equals, "001");
            //q.Execute();

            //-------------
            //可行----删除记录
           // Query q = new DeleteQuery(Address.Schema)
           //.AddWhere(Address.CodeColumn.ColumnName, Comparison.Equals, "001");
           // q.Execute();

            //--------
            //这种方式会新增新的记录, 并不会去判断是否有存在记录--新增
            //Address a = new Address();
            //a.Code = "china";
            //a.No = "888";
            //a.Email = "dlk";

            //AddressCollection add = new AddressCollection();
            //add.Add(a);
            //a = new Address();
            //a.Code = "001";
            //a.No = "006";
            //a.Email = "dlk";
            //add.Add(a);
            //add.SaveAll();

           //--------------