C# lambda中使用sql语句

在C# Lambda中使用SQL语句通常需要使用LINQ（Language Integrated Query）的语法，这样可以将SQL语句转换为Lambda表达式。以下是使用Lambda表达式执行SQL语句的示例：

查询数据

//使用Lambda表达式查询数据 var result = dbContext.Customers.Where(c => c.City == "Beijing").ToList();

//等效的SQL语句 SELECT * FROM Customers WHERE City = 'Beijing'

插入数据

//使用Lambda表达式插入数据 var newCustomer = new Customer { Name = "New Customer", City = "Shanghai", Country = "China" }; dbContext.Customers.Add(newCustomer); dbContext.SaveChanges();

//等效的SQL语句 INSERT INTO Customers (Name, City, Country) VALUES ('New Customer', 'Shanghai', 'China')

更新数据

//使用Lambda表达式更新数据 var customer = dbContext.Customers.Where(c => c.Id == 1).FirstOrDefault(); if (customer != null) { customer.City = "Beijing"; dbContext.SaveChanges(); }

//等效的SQL语句 UPDATE Customers SET City = 'Beijing' WHERE Id = 1

删除数据

//使用Lambda表达式删除数据 var customer = dbContext.Customers.Where(c => c.Id == 1).FirstOrDefault(); if (customer != null) { dbContext.Customers.Remove(customer); dbContext.SaveChanges(); }

//等效的SQL语句 DELETE FROM Customers WHERE Id =