Esempio n. 1
0
        static void Main(string[] args)
        {
            // Der NonGUID Part
            Console.WriteLine("NO GUID");

            DataClassesNoGuidDataContext noGuidContext = new DataClassesNoGuidDataContext();

            NoGuidProduct product = new NoGuidProduct();

            product.Name  = "Tolles Produkt";
            product.Price = 14;
            noGuidContext.NoGuidProducts.InsertOnSubmit(product);
            noGuidContext.SubmitChanges();

            Console.WriteLine("Auslesen");
            Table <NoGuidProduct> noguidProductTable = noGuidContext.GetTable <NoGuidProduct>();
            var noguidProducts = from noguidP in noguidProductTable
                                 select noguidP;

            foreach (NoGuidProduct resultProduct in noguidProducts)
            {
                Console.WriteLine(resultProduct.Name + " (" + resultProduct.Id + " )");
            }



            // Der GUID Part
            DataClassesGuidDataContext guidContext = new DataClassesGuidDataContext();

            Console.WriteLine("GUID");

            GuidProduct guidProduct = new GuidProduct();

            guidProduct.Id    = Guid.NewGuid();
            guidProduct.Name  = "Tolles Guid Produkt";
            guidProduct.Price = 313;

            GuidProduct anotherGuidProduct = new GuidProduct();

            anotherGuidProduct.Id    = Guid.NewGuid();
            anotherGuidProduct.Name  = "Tolles anderes Guid Produkt";
            anotherGuidProduct.Price = 132;

            GuidReleatedProduct relation = new GuidReleatedProduct();

            relation.Id              = Guid.NewGuid();
            relation.ProductIdFirst  = guidProduct.Id;
            relation.ProductIdSecond = anotherGuidProduct.Id;

            guidContext.GuidProducts.InsertOnSubmit(guidProduct);
            guidContext.GuidProducts.InsertOnSubmit(anotherGuidProduct);
            guidContext.GuidReleatedProducts.InsertOnSubmit(relation);

            guidContext.SubmitChanges();

            Console.WriteLine("Auslesen");

            Table <GuidProduct> guidProductTable = guidContext.GetTable <GuidProduct>();
            var guidProducts = from guidP in guidProductTable
                               select guidP;

            foreach (GuidProduct resultProduct in guidProducts)
            {
                Console.WriteLine(resultProduct.Name);
                foreach (GuidReleatedProduct relatedProducts in resultProduct.GuidReleatedProductsFirst)
                {
                    Console.WriteLine(" - " + relatedProducts.GuidProduct.Name);
                }
            }

            Console.ReadLine();
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            // Der NonGUID Part
            Console.WriteLine("NO GUID");
            
            DataClassesNoGuidDataContext noGuidContext = new DataClassesNoGuidDataContext();
           
            NoGuidProduct product = new NoGuidProduct();
            product.Name = "Tolles Produkt";
            product.Price = 14;
            noGuidContext.NoGuidProducts.InsertOnSubmit(product);
            noGuidContext.SubmitChanges();

            Console.WriteLine("Auslesen");
            Table<NoGuidProduct> noguidProductTable = noGuidContext.GetTable<NoGuidProduct>();
            var noguidProducts = from noguidP in noguidProductTable
                               select noguidP;

            foreach (NoGuidProduct resultProduct in noguidProducts)
            {
                Console.WriteLine(resultProduct.Name + " (" + resultProduct.Id + " )");
            }


            

            // Der GUID Part
            DataClassesGuidDataContext guidContext = new DataClassesGuidDataContext();

            Console.WriteLine("GUID");

            GuidProduct guidProduct = new GuidProduct();
            guidProduct.Id = Guid.NewGuid();
            guidProduct.Name = "Tolles Guid Produkt";
            guidProduct.Price = 313;

            GuidProduct anotherGuidProduct = new GuidProduct();
            anotherGuidProduct.Id = Guid.NewGuid();
            anotherGuidProduct.Name = "Tolles anderes Guid Produkt";
            anotherGuidProduct.Price = 132;
            
            GuidReleatedProduct relation = new GuidReleatedProduct();
            relation.Id = Guid.NewGuid();
            relation.ProductIdFirst = guidProduct.Id;
            relation.ProductIdSecond = anotherGuidProduct.Id;

            guidContext.GuidProducts.InsertOnSubmit(guidProduct);
            guidContext.GuidProducts.InsertOnSubmit(anotherGuidProduct);
            guidContext.GuidReleatedProducts.InsertOnSubmit(relation);

            guidContext.SubmitChanges();

            Console.WriteLine("Auslesen");
            
            Table<GuidProduct> guidProductTable = guidContext.GetTable<GuidProduct>();
            var guidProducts = from guidP in guidProductTable
                               select guidP;

            foreach (GuidProduct resultProduct in guidProducts)
            {
                Console.WriteLine(resultProduct.Name);
                foreach(GuidReleatedProduct relatedProducts in resultProduct.GuidReleatedProductsFirst)
                {
                    Console.WriteLine(" - " + relatedProducts.GuidProduct.Name);
                }
            }

            Console.ReadLine();
        }