public List <BranchModel> GetAllBranches() { DataTable dt = new DataTable(); List <BranchModel> arrBranches = new List <BranchModel>(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(BranchStringsSql.GetAllBranches()); } foreach (DataRow ms in dt.Rows) { arrBranches.Add(BranchModel.ToObject(ms)); } return(arrBranches); }