EF调用存储过程

最新推荐文章于 2024-02-15 11:00:00 发布

碧山云游

最新推荐文章于 2024-02-15 11:00:00 发布

阅读量283

点赞数

分类专栏： EntityFramework学习

本文链接：https://blog.csdn.net/qq_41617901/article/details/118420141

版权

EntityFramework学习专栏收录该内容

2 篇文章 0 订阅

订阅专栏

 public int PublishNews(News news)
        {
            SqlParameter[] param = new SqlParameter[]
             {
                new SqlParameter("@NewsTitle",news.NewsTitle),
                new SqlParameter("@NewsContents",news.NewsContents),
                new SqlParameter("@CategoryId",news.CategoryId)
             };
            using (HotelDBEntities db = new DAL.HotelDBEntities())
            {
                return db.Database.ExecuteSqlCommand("execute usp_AddNews @NewsTitle,@NewsContents,@CategoryId", param);
            }
        }

sql脚本：

use HotelDB
go

--发布新闻
if exists  (select * from sysobjects  where name='usp_AddNews')
drop procedure usp_AddNews
go
create procedure usp_AddNews
@NewsTitle varchar(100), 
@NewsContents text, 
@CategoryId int
as
	insert into News(NewsTitle, NewsContents, CategoryId)
	values(@NewsTitle, @NewsContents, @CategoryId)
	--得到上一次插入记录时自动产生的ID
	select @@IDENTITY
go

if exists  (select * from sysobjects  where name='usp_ModifyDishes')
drop procedure usp_ModifyDishes
go
create  procedure usp_ModifyDishes
@DishesId int, 
@DishesName varchar(100), 
@UnitPrice numeric(18,2), 
@CategoryId int
as
	update Dishes set  DishesName=@DishesName, UnitPrice=@UnitPrice, 
	CategoryId=@CategoryId where  DishesId=@DishesId
go

create table Dishes --菜品表
(
	DishesId int  identity(100,1)  primary key , --菜品编号
	DishesName varchar(100),--菜品名称
	UnitPrice numeric(18,2), --价格
	CategoryId int references DishesCategory(CategoryId)--分类编号
)
go