예제 #1
0
        static void Main(string[] args)
        {
            risTabulky risContext = new risTabulky();

            stol stol = new stol
            {
                id_stola    = 1,
                pocet_miest = 6
            };

            //insert
            risContext.stol.Add(stol);

            risContext.SaveChanges();

            //update

            try
            {
                stol stolUpdate = new stol
                {
                    id_stola    = 8,
                    pocet_miest = 10
                };
                risContext.stol.Attach(stolUpdate);

                var entry = risContext.Entry(stolUpdate);
                entry.State = EntityState.Modified;

                entry.Property(e => e.pocet_miest).IsModified = true;

                risContext.SaveChanges();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.InnerException.ToString());
            }


            //delete
            stol stolDelete = risContext.stol.First(i => i.id_stola == stol.id_stola);

            risContext.stol.Remove(stolDelete);
            risContext.SaveChanges();
        }
예제 #2
0
        static void Main(string[] args)
        {
            risTabulky risContext = new risTabulky();

            stol stol = new stol
            {
                id_stola = 1,
                pocet_miest = 6
            };
            //insert
            risContext.stol.Add(stol);

            risContext.SaveChanges();

            //update

            try
            {
                stol stolUpdate = new stol
                {
                    id_stola = 8,
                    pocet_miest = 10

                };
                risContext.stol.Attach(stolUpdate);

                var entry = risContext.Entry(stolUpdate);
                entry.State = EntityState.Modified;

                entry.Property(e => e.pocet_miest).IsModified = true;

                risContext.SaveChanges();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.InnerException.ToString());
            }

            //delete
            stol stolDelete = risContext.stol.First(i => i.id_stola == stol.id_stola);
            risContext.stol.Remove(stolDelete);
            risContext.SaveChanges();
        }