public List <RolePaginationViewModel> GetRole_Pagination(int Skip) { var result = new List <RolePaginationViewModel>(); var obj = new RolePaginationViewModel(); using (NpgsqlConnection connection = new NpgsqlConnection(ConfigureSetting.GetConnectionString)) { connection.Open(); string sql = "sp_rolepagination"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@skip", NpgsqlTypes.NpgsqlDbType.Integer, Skip); using (var reader = command.ExecuteReader()) { result = DataReaderMap.DataReaderMapToList <RolePaginationViewModel>(reader); } } connection.Close(); } return(result); }
public List <RolePaginationViewModel> GetRole_Pagination(int Skip) { var result = new List <RolePaginationViewModel>(); var obj = new RolePaginationViewModel(); using (AstonContext dbContext = new AstonContext()) { dbContext.Database.OpenConnection(); DbCommand cmd = dbContext.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "dbo.sp_RolePagination"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Skip", SqlDbType.Int) { Value = Skip }); using (var reader = cmd.ExecuteReader()) { var Rolelist = dbContext.DataReaderMapToList <RolePaginationViewModel>(reader); foreach (var Role in Rolelist) { result.Add(Role); } cmd.Connection.Close(); } } return(result); }