Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Manish Kumar 1486 24 May 2018

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

Manish Kumar

Other

1 Answers

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..

MindStick Training