关于EF中的存储过程使用

最新推荐文章于 2022-01-21 21:28:37 发布

原创最新推荐文章于 2022-01-21 21:28:37 发布 · 416 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#EF #存储过程

.NET MVC 专栏收录该内容

8 篇文章

订阅专栏

首先是后台代码

  //登陆存储过程
            List<SqlParameter> paramArray = new List<SqlParameter>();
            paramArray.Add(new SqlParameter("@name", name));
            paramArray.Add(new SqlParameter("@pwd", pwd));
            SqlParameter param = new SqlParameter("@num", SqlDbType.Int);
            param.Direction = ParameterDirection.Output;
            paramArray.Add(param);
//注意这里 JSEntities 是数据库模型 using (JS5Entities db = new JS5Entities())

{ try { db.Database.ExecuteSqlCommand("EXEC [Login_Proc] @name,@pwd,@num out", paramArray.ToArray()); } catch (Exception ex) { throw; } loginPd = (int)paramArray[2].Value; } if (loginPd > 0) { JsonStr = "cg"; } else { JsonStr = "gg"; }

PS.补充数据库模型

   public class JS5Entities : DbContext
    {
        public JS5Entities() : base("name=JS5Entities")
        {

        }

        //protected override void onModelCreateing(DbModelBuilder modelBuilder)
        //{
        //    throw new UnintentionalCodeFirstException();
        //}


        public DbSet<Goods> Goods { get; set; }
        public DbSet<Orders> Orders { get; set; }
        public DbSet<Typec> Typec { get; set; }
        public DbSet<Users> Users { get; set; }
        public DbSet<Webs> Webs { get; set; }

    }

数据库中存储过程

--登陆存储过程
ALTER PROCEDURE [dbo].[Login_Proc]
@name VARCHAR(100),
@psd VARCHAR(100),
@num INT OUTPUT
AS
  SET NOCOUNT ON;
  DECLARE @ins INT
	SET @ins=0
  SELECT @ins=COUNT(1) FROM Users WHERE Users.Us_Name=@name and Users.Us_Pwd=@psd
  if(@ins>0)
  BEGIN
--登陆成功
   SET @num=1 
  END
  ELSE
  BEGIN 
--登陆失败
		SET @num=0
  END