Exemple #1
0
        private static async Task SetLink_ThenRemoveLink_ThenUpdate_ThenDelete_CompoundKey()
        {
            var dataServiceContext = new ODataServiceContextFactory().Create(url);

            var book = new Book()
            {
                Id = "Id" + RandomInt(), Title = "Title " + RandomInt()
            };
            var publisher = new Publisher()
            {
                Title = "New Publisher " + RandomInt()
            };

            dataServiceContext.AddObject("Books", book);
            dataServiceContext.AddObject("Publishers", publisher);

            dataServiceContext.SetLink(book, nameof(Book.Publisher), publisher);

            var dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);

            dataServiceContext.SetLink(book, nameof(Book.Publisher), null);

            dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);

            publisher.Title = publisher.Title + " Changed";

            dataServiceContext.UpdateObject(publisher);
            dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);

            dataServiceContext.DeleteObject(publisher);
            dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);
        }
Exemple #2
0
        private static async Task Batch_UniqueKeyViolation()
        {
            var dataServiceContext = new ODataServiceContextFactory().Create(url);

            try
            {
                dataServiceContext.AddObject("Authors", new Author()
                {
                    LastName = new Random().Next(1, 100000).ToString()
                });
                dataServiceContext.AddObject("Authors", new Author()
                {
                    LastName = "Asimov"
                });
                dataServiceContext.AddObject("Authors", new Author()
                {
                    LastName = new Random().Next(1, 100000).ToString()
                });

                var dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.BatchWithSingleChangeset);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
        }
Exemple #3
0
        private static async Task Products_CRUD()
        {
            var dataServiceContext = new ODataServiceContextFactory().Create(url);
            var products           = await((DataServiceQuery <Product>)dataServiceContext.Products.Take(3)).ExecuteAsync();

            var product = new Product {
                Name = "OData"
            };

            dataServiceContext.AddObject("Products", product);

            await dataServiceContext.SaveChangesAsync();

            product.Name = "OData renamed";
            dataServiceContext.UpdateObject(product);

            await dataServiceContext.SaveChangesAsync();

            dataServiceContext.DeleteObject(product);

            await dataServiceContext.SaveChangesAsync();
        }
Exemple #4
0
        private static async Task AddLink_Then_DeleteLink_CompoundKey()
        {
            var dataServiceContext = new ODataServiceContextFactory().Create(url);

            var book = new Book()
            {
                Id = "Id" + RandomInt(), Title = "Title " + RandomInt()
            };
            var publisher = new Publisher()
            {
                Title = "New Publisher " + RandomInt()
            };

            dataServiceContext.AddObject("Publishers", publisher);
            dataServiceContext.AddObject("Books", book);
            dataServiceContext.AddLink(publisher, "Books", book);

            var dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);

            dataServiceContext.DeleteLink(publisher, "Books", book);

            dataServiceResponse = await dataServiceContext.SaveChangesAsync(SaveChangesOptions.None);
        }