entity framework call stored procedure with parameters

BlackSwan answered on August 13, 2021 Popularity 9/10 Helpfulness 4/10

answer entity framework call stored procedure with parameters

related calling stored procedure in c# entity framework

entity framework call stored procedure with parameters

Comment

  using (var entities = new YourEntities())
                {
                    SqlParameter[] parameters =
                      {
                          new SqlParameter{
                                SqlDbType = SqlDbType.NVarChar,
                                Size = -1,
                                Direction = ParameterDirection.Input,
                                ParameterName = "InCompanyCode",
                                Value = SD.Company
                            },
                            new SqlParameter{
                                SqlDbType = SqlDbType.NVarChar,
                                Size = -1,
                                Direction = ParameterDirection.Input,
                                ParameterName = "InDebugModeOn",
                                Value = "0"
                            }
                        };

                   return entities.Database.SqlQuery<Your_Model>
                        (@"EXECUTE YourSP @InCompanyCode,@InBranchCode", parameters).ToList();                }

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: Grepper

Tags: call entity-framework parameters procedure whatever

Link to this answer
Share Copy Link

Contributed on Jan 05 2022

BlackSwan

0 Answers Avg Quality 2/10

Closely Related Answers

calling stored procedure in c# entity framework

Comment

using (var db = new SyXEntities())
{
	var repeatDetails = db.Database.SqlQuery<RepeatBetDetail>("Get_RepeatBetDetails @BetID", new SqlParameter("BetID", betID)).ToList();
	return repeatDetails;
}

Popularity 10/10 Helpfulness 5/10 Language csharp

Source: Grepper

Tags: c# c

Link to this answer
Share Copy Link

Contributed on Aug 13 2021

Fortune Mbulazi

0 Answers Avg Quality 2/10

entity framework call stored procedure with parameters

Contents

More Related Answers

entity framework call stored procedure with parameters

Closely Related Answers

calling stored procedure in c# entity framework

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.