LinQ To Entity的增删改查

本示例程序采用Northwind 示例数据库,下面开始编写代码对Customers表进行增、删、改、查等等操作。

 

1.新增Customers记录

            using (NorthwindEntities myDb = new NorthwindEntities())

            {

                Customers customer = new Customers();

 

                Random rm = new Random();

 

                customer.CustomerID = "A" + rm.Next(9999).ToString();

                customer.CompanyName = "EntLib.com Forum";

                customer.Address = "http://www.EntLib.com";

 

                myDb.AddToCustomers(customer);

 

                int count = myDb.SaveChanges();

 

                txtCustomerID.Text = customer.CustomerID;

            }

 

2.更新Customers记录

            using (NorthwindEntities myDb = new NorthwindEntities())

            {

                var query = from customer in myDb.Customers

                            where customer.CustomerID == txtCustomerID.Text.Trim()

                            select customer;

 

                foreach (var row in query)

                {

                    row.CompanyName = "Updated Company Name";

                }

 

                myDb.SaveChanges();

            }

 

3.删除Customers记录

            using (NorthwindEntities myDb = new NorthwindEntities())

            {

                var query = from customer in myDb.Customers

                            where customer.CustomerID == txtCustomerID.Text.Trim()

                            select customer;

 

                foreach (var row in query)

                {

                    myDb.DeleteObject(row);

                }

 

                myDb.SaveChanges();

            }

 

4.查询Customers,返回所有记录

            using (NorthwindEntities myDb = new NorthwindEntities())

            {

                dataGridView1.DataSource = myDb.Customers;

            }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值