Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (var db = new Entities())
- {
- var cmd = db.Database.Connection.CreateCommand();
- cmd.CommandText = "[dbo].[sp_Getadeta]";
- 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 list = ((IObjectContextAdapter)db).ObjectContext.Translate<MyClass>(result).ToList();
- query = list;
- }
- }
- finally
- {
- db.Database.Connection.Close();
- cmd.Dispose();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement