Exemplos de BDSA2019.Lecture04 RawSql em C# (CSharp)

Exemplo n.º 1

        public static void Run()
        {
            var connectionString = @"Server=(localdb)\MSSQLLocalDB;Database=Futurama;Trusted_Connection=True;MultipleActiveResultSets=true";

            using (var raw = new RawSql(connectionString))
            {
                Read(raw);

                PrintHeader("READ('Turanga Leela')");

                var leela = raw.Read("Turanga Leela");
                Console.WriteLine(leela);

                PrintHeader("DELETE(2)");

                raw.Delete(2);

                Read(raw);

                PrintHeader("UPDATE - move fry to Mars");

                var fry = raw.Read("Philip J. Fry");
                fry.Planet = "Mars";
                raw.Update(fry);

                Read(raw);
            }
        }

Exemplo n.º 2

        static void Read(RawSql raw)
        {
            PrintHeader("READ");

            foreach (var character in raw.Read())
            {
                Console.WriteLine(character);
            }
        }