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

How to get Generic List from stored procedure by using entity framework ?

Anonymous User 1260 29 Jun 2019

Please explain with a suitable example...

Anonymous User

A_Philosopher

I am a content writter !

1 Answers

Anonymous User 02 Jul 2019 Accepted Answer

Try to use it with entity framework.

 public void ExecuteList<T>(out List<T> obj, string sql, params object[] parameters) where T : class

        {

            var db = _context;

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

            cmd.CommandText = sql;

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddRange(parameters);

            try

            {

                db.Database.Connection.Open();

                using (var reder = cmd.ExecuteReader())

                {

                    obj = ((IObjectContextAdapter)db).ObjectContext.Translate<T>(reder).ToList();



                }

            }

            finally

            {

                db.Database.Connection.Close();

                cmd.Dispose();

            }



        }

advertising