forum

home / developersection / forums / how to return multiple generic lists from a method using entity framework ?

Ask Question
Anonymous User

Anonymous User

Follow

I am a content writter !

Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

02-Jul-2019

Try to use overloaded method. 

  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();

            }



        }

        /// <summary>

        /// 

        /// </summary>

        /// <typeparam name="T"></typeparam>

        /// <typeparam name="T1"></typeparam>

        /// <param name="obj"></param>

        /// <param name="obj1"></param>

        /// <param name="sql"></param>

        /// <param name="parameters"></param>

        public void ExecuteList<T, T1>(out List<T> obj, out List<T1> obj1, 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();

                    reder.NextResult();

                    obj1 = ((IObjectContextAdapter)db).ObjectContext.Translate<T1>(reder).ToList();

                }

            }

            finally

            {

                db.Database.Connection.Close();

                cmd.Dispose();

            }



        }

        /// <summary>

        /// 

        /// </summary>

        /// <typeparam name="T"></typeparam>

        /// <typeparam name="T1"></typeparam>

        /// <typeparam name="T2"></typeparam>

        /// <param name="obj"></param>

        /// <param name="obj1"></param>

        /// <param name="obj2"></param>

        /// <param name="sql"></param>

        /// <param name="parameters"></param>

        public void ExecuteList<T, T1, T2>(out List<T> obj, out List<T1> obj1, out List<T2> obj2, 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();



                    reder.NextResult();

                    obj1 = ((IObjectContextAdapter)db).ObjectContext.Translate<T1>(reder).ToList();

                    reder.NextResult();

                    obj2 = ((IObjectContextAdapter)db).ObjectContext.Translate<T2>(reder).ToList();

                }

            }

            finally

            {

                db.Database.Connection.Close();

                cmd.Dispose();

            }



        }


Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy