EntityFramework执行SQL语句
来源:互联网 发布:成都程序员 编辑:程序博客网 时间:2024/06/14 11:15
在EF中执行Sql语句。
Insert Code:
using (var context = new EFRecipesEntities())
{
string sql = @"insert into Chapter3.Payment(Amount, Vendor)
values (@Amount, @Vendor)";
var args = new DbParameter[] {
new SqlParameter { ParameterName = "Amount", Value = 99.97M},
new SqlParameter { ParameterName = "Vendor", Value="Ace Plumbing"}
};
int rowCount = context.ExecuteStoreCommand(sql, args);
}
{
string sql = @"insert into Chapter3.Payment(Amount, Vendor)
values (@Amount, @Vendor)";
var args = new DbParameter[] {
new SqlParameter { ParameterName = "Amount", Value = 99.97M},
new SqlParameter { ParameterName = "Vendor", Value="Ace Plumbing"}
};
int rowCount = context.ExecuteStoreCommand(sql, args);
}
select all code:
using (var context = new EFRecipesEntities())
{
string sql = "select * from Chapter3.Student where Degree = @Major";
var args = new DbParameter[] {
new SqlParameter {ParameterName = "Major", Value = "Masters"}};
var students = context.ExecuteStoreQuery<Student>(sql, args);
Console.WriteLine("Students...");
foreach (var student in students)
{
Console.WriteLine("{0} {1} is working on a {2} degree",
student.FirstName, student.LastName, student.Degree);
}
}
{
string sql = "select * from Chapter3.Student where Degree = @Major";
var args = new DbParameter[] {
new SqlParameter {ParameterName = "Major", Value = "Masters"}};
var students = context.ExecuteStoreQuery<Student>(sql, args);
Console.WriteLine("Students...");
foreach (var student in students)
{
Console.WriteLine("{0} {1} is working on a {2} degree",
student.FirstName, student.LastName, student.Degree);
}
}
select specific column
using (var conn = new EntityConnection("name=EFRecipesEntities"))
{
var cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = @"select c.Name, C.Email from
EFRecipesEntities.Customers as c";
using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
Console.WriteLine("{0}'s email is: {1}",
reader.GetString(0), reader.GetString(1));
}
}
}
{
var cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = @"select c.Name, C.Email from
EFRecipesEntities.Customers as c";
using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
Console.WriteLine("{0}'s email is: {1}",
reader.GetString(0), reader.GetString(1));
}
}
}
0 0
- EntityFramework执行SQL语句
- EntityFramework 执行SQL语句进行参数化查询代码示例
- EntityFramework 4/5/6 中执行自定义SQL语句
- EntityFramework中使用sql语句
- EntityFramework Any 生成的sql语句超长。
- 获得EntityFramework生成的SQL语句
- SQL语句执行组件
- SQL语句执行顺序
- php执行sql语句
- 动态执行sql语句
- AIR执行SQL语句
- Jdbc执行sql语句
- sql语句执行原理
- sql 语句 执行顺序
- SQL语句执行分析
- sql语句批量执行
- SQL语句执行顺序
- SQL语句执行顺序
- aspcms留言增加防刷新验证,单一ip留言条数限制,防止恶意刷新及恶意提交。
- 李开复:年轻人该比谁更拼命吗?
- MF-800U
- R语言与机器学习学习笔记(分类算法)(3)朴素贝叶斯
- UHF桌面式发卡器
- EntityFramework执行SQL语句
- C++中this指针的用法详解
- 几种常见卡的简单介绍
- VC中打开对话框选择文件和文件夹
- 炜煌T3POS58微打参数设置方法
- 扬声器音量设置
- 重新注册国家局基础软件
- MySql 数据库部分字段区分大小写
- 自动化收购线提示烟筐卡号不存在的错误