public Result Update(List <MenuEntity> list, string type) { var con = new DapperConnectionManager(); var queryList = new List <QueryEntity>(); var query = new QueryEntity { Query = @"DELETE from Menus WHERE Type = @Type", Entity = new { Type = type }, }; queryList.Add(query); foreach (var item in list) { item.Type = type; var queryItem = new QueryEntity() { Entity = item, Query = @"INSERT into Menus (Title, Href, Position, Type, Submenu, Separator) VALUES(@Title, @Href, @Position, @Type, @Submenu, @Separator)" }; queryList.Add(queryItem); } var result = con.ExecuteQueries(queryList); result.Message = result.Success ? "The menu have been modifed" : "An error has ocurred"; return(result); }