samples/snippets/csharp/VS_Snippets_Data/DLinqDebuggingSupport/cs/Program.cs - main - aprogrammer/dotnet-docs

samples/snippets/csharp/VS_Snippets_Data/DLinqDebuggingSupport/cs/Program.cs

84 строки2 KB

Next Turn

Normalizes trailing spaces in samples, Part 1 (#17895)

17 апр 2020, 19:02

17 апр 2020, 19:0263ee2a4

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Linq;
using System.Data.Common;

namespace cs_debuggingsupport
{
    class Program
    {
        static void Main(string[] args)
        {

            Northwnd db = new Northwnd(@"c:\northwnd.mdf");

            // <Snippet1>
            db.Log = Console.Out;
            IQueryable<Customer> custQuery =
                from cust in db.Customers
                where cust.City == "London"
                select cust;

            foreach(Customer custObj in custQuery)
            {
                Console.WriteLine(custObj.CustomerID);
            }
            // </Snippet1>
        }

        void method2()
        {
            // <Snippet2>
            Northwnd db = new Northwnd(@"c:\northwnd.mdf");

            var custQuery =
                from cust in db.Customers
                where cust.City == "London"
                select cust;

            foreach (Customer custObj in custQuery)
            {
                Console.WriteLine("CustomerID: {0}", custObj.CustomerID);
                Console.WriteLine("\tOriginal value: {0}", custObj.City);
                custObj.City = "Paris";
                Console.WriteLine("\tUpdated value: {0}", custObj.City);
            }

            ChangeSet cs = db.GetChangeSet();
            Console.Write("Total changes: {0}", cs);
            // Freeze the console window.
            Console.ReadLine();

            db.SubmitChanges();
            // </Snippet2>
        }

        void method3()
        {
            // <Snippet3>
            // using System.Data.Common;
            Northwnd db = new Northwnd(@"c:\northwnd.mdf");

            var q =
                from cust in db.Customers
                where cust.City == "London"
                select cust;

            Console.WriteLine("Customers from London:");
            foreach (var z in q)
            {
                Console.WriteLine("\t {0}",z.ContactName);
            }

            DbCommand dc = db.GetCommand(q);
            Console.WriteLine("\nCommand Text: \n{0}",dc.CommandText);
            Console.WriteLine("\nCommand Type: {0}",dc.CommandType);
            Console.WriteLine("\nConnection: {0}",dc.Connection);

            Console.ReadLine();
            // </Snippet3>
        }
    }
}