C# (CSharp) ContactDBLinq1 ContactDB Examples

Example #1

File: Program.cs Project: breaker/studies

        static void Main(string[] args)
        {
            string connectionString = "Data Source=|DataDirectory|\\ContactDB.sdf";
            // 用 SqlMetal 产生的 LINQ to SQL class
            // ContactDB 是 Linq.DataContext 的派生类
            ContactDB context = new ContactDB(connectionString);
            var peopleData =
            from person in context.People
            select new { person.Name, person.Company };
            foreach (var person in peopleData)
            Console.WriteLine("{0} works at {1}", person.Name, person.Company);

            #if DEBUG
            Console.ReadKey();
            #endif
        }

Example #2

        static void Main(string[] args)
        {
            string connectionString = "Data Source=|DataDirectory|\\ContactDB.sdf";
            // 用 SqlMetal 产生的 LINQ to SQL class
            // ContactDB 是 Linq.DataContext 的派生类
            ContactDB context    = new ContactDB(connectionString);
            var       peopleData =
                from person in context.People
                select new { person.Name, person.Company };

            foreach (var person in peopleData)
            {
                Console.WriteLine("{0} works at {1}", person.Name, person.Company);
            }

#if DEBUG
            Console.ReadKey();
#endif
        }