forum

Home / DeveloperSection / Forums / Call stored procedures with Entity Framework 6 data first approach in Asp.Net MVC 4

Ask Question

Call stored procedures with Entity Framework 6 data first approach in Asp.Net MVC 4

Manish Kumar111624-May-2018

I am using mvc framerwork 4.5 with entityframework 6.0 .Can someone tell me how to call store procedure with parameter 


asp.netasp.net asp.net mvc 
Updated on 24-May-2018
Manish Kumar

Manish Kumar

Follow

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

24-May-2018

I telling you how to get record using store procedure 

 using (var db = new MindStickDBEntities())

                    {

                        var cmd = db.Database.Connection.CreateCommand();

                        cmd.CommandText = "[dbo].[Sp_Getrecord]";

                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.Add(new SqlParameter("@pageNo", pageNo));

                        cmd.Parameters.Add(new SqlParameter("@pageSize", pageSize));



                        try

                        {

                            db.Database.Connection.Open();

                            using (var result = cmd.ExecuteReader())

                            {

                                var recordlist= ((IObjectContextAdapter)db).ObjectContext.Translate<PostModel>(result).ToList();

                                result.NextResult(); 





                            }



                        }

hope it helps you..

Liked By