Optimize a Query

I use the following code snippet. Can it be optimized?
My menu is a comma separated string field and I want to save each field in a table field.

  public void AddMenu(string Menu, int test)
        {
            string[] MenuList = Menu.Split(",");
            List<Menu> menus = new List<Menu>();
            foreach (var item in MenuList)
            {
                Menu m = new Menu();
                m.Name = item;
                m.test= test;
                menus.Add(m);
            }
            _context.AddRange(menus);
        }

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.