{"id":415,"date":"2011-05-23T16:33:01","date_gmt":"2011-05-23T16:33:01","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?p=415"},"modified":"2018-05-31T21:04:47","modified_gmt":"2018-05-31T21:04:47","slug":"consuming-external-odata-feeds-with-sharepoint-bcs","status":"publish","type":"post","link":"https:\/\/www.ericwhite.com\/blog\/2011\/05\/23\/consuming-external-odata-feeds-with-sharepoint-bcs\/","title":{"rendered":"Consuming External OData Feeds with SharePoint BCS"},"content":{"rendered":"

I wrote an MSDN Magazine article, Consuming External OData Feeds with SharePoint BCS<\/a>, which was published in April, 2011.\u00a0 Using BCS, you can connect up to SQL databases and web services without writing any code, but if you have more exotic data sources, you can write C# code that can grab the data from anywhere you can get it.\u00a0 Knowing how to write an assembly connector is an important skill for pro developers who need to work with BCS.\u00a0 This article shows how to write a .NET Assembly Connector for BCS.\u00a0 It uses as its data source an OData feed.\u00a0 Of course, as you probably know, SharePoint 2010 out-of-the-box exposes lists as OData feeds.\u00a0 The MSDN article does a neat trick \u2013 you write a .NET assembly connector that consumes an OData feed for a list that is on the same site.\u00a0 While this, by itself, is not very useful, it means that it is super easy to walk through the process of writing a .NET assembly connector.<\/p>\n

I write the article and the code for the 2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM).\u00a0 Some time ago, I wrote a blog post, How to Install and Activate the IW Demo\/Evaluation Hyper-V Machine<\/a>.<\/p>\n

The MSDN article contains detailed instructions on how to create a read-only external content type that consumes an OData feed.\u00a0 This is an interesting exercise, but advanced developers will want to create .NET assembly connectors that can create\/read\/update\/delete records.\u00a0 The procedures for doing all of that were too long for the MSDN magazine article, so of necessity, the article is limited to creating a read-only ECT.<\/p>\n

However, I have recorded a screen-cast that walks through the entire process of creating a CRUD capable ECT.\u00a0 It is 25 minutes long, so some day when you feel patient, you can follow along step-by-step-by-step, creating a CRUD capable ECT that consumes an OData feed.\u00a0 Here is the video:<\/p>\n

\n
<\/embed><\/object><\/div>\n
Walks through the process of creating an ,NET connector for an ECT that consumes an OData feed.<\/div>\n<\/div>\n

\nThe procedure requires code for two source code modules: Customer.cs, and CustomerService.cs.<\/p>\n

Here is the code for Customer.cs:<\/p>\n


\nusing System;
\nusing System.Collections.Generic;
\nusing System.Linq;
\nusing System.Text;<\/p>\n

namespace Contoso.Crm
\n{
\n    public partial class Customer
\n    {
\n        public string CustomerID { get; set; }
\n        public string CustomerName { get; set; }
\n        public int Age { get; set; }
\n    }
\n}
\n<\/code><\/p>\n

Here is the code for CustomerService.cs:<\/p>\n


\nusing System;
\nusing System.Collections.Generic;
\nusing System.Linq;
\nusing System.Net;
\nusing System.Text;<\/p>\n

namespace Contoso.Crm
\n{
\n    public class CustomerService
\n    {
\n        public static Customer ReadCustomer(string customerID)
\n        {
\n            TeamSiteDataContext dc =
\n                new TeamSiteDataContext(
\n                    new Uri(\"http:\/\/intranet.contoso.com\/_vti_bin\/listdata.svc\"));
\n            dc.Credentials = CredentialCache.DefaultNetworkCredentials;
\n            var customers =
\n                from c in dc.Customers
\n                where c.CustomerID == customerID
\n                select new Customer()
\n                {
\n                    CustomerID = c.CustomerID,
\n                    CustomerName = c.CustomerName,
\n                    Age = (int)c.Age,
\n                };
\n            return customers.FirstOrDefault();
\n        }<\/p>\n

        public static IEnumerable<Customer> ReadCustomerList()
\n        {
\n            TeamSiteDataContext dc =
\n                new TeamSiteDataContext(
\n                    new Uri(\"http:\/\/intranet.contoso.com\/_vti_bin\/listdata.svc\"));
\n            dc.Credentials = CredentialCache.DefaultNetworkCredentials;
\n            var customers =
\n                from c in dc.Customers
\n                select new Customer()
\n                {
\n                    CustomerID = c.CustomerID,
\n                    CustomerName = c.CustomerName,
\n                    Age = (int)c.Age,
\n                };
\n            return customers;
\n        }<\/p>\n

        public static void UpdateCustomer(Customer customer)
\n        {
\n            TeamSiteDataContext dc =
\n                new TeamSiteDataContext(
\n                    new Uri(\"http:\/\/intranet.contoso.com\/_vti_bin\/listdata.svc\"));
\n            dc.Credentials = CredentialCache.DefaultNetworkCredentials;
\n            var query =
\n                from c in dc.Customers
\n                where c.CustomerID == customer.CustomerID
\n                select new Customer()
\n                {
\n                    CustomerID = c.CustomerID,
\n                    CustomerName = c.CustomerName,
\n                    Age = (int)c.Age,
\n                };
\n            var customerToUpdate = query.FirstOrDefault();
\n            customerToUpdate.CustomerName = customer.CustomerName;
\n            customerToUpdate.Age = customer.Age;
\n            dc.UpdateObject(customerToUpdate);
\n            dc.SaveChanges();
\n        }<\/p>\n

        public static void DeleteCustomer(string customerID)
\n        {
\n            TeamSiteDataContext dc =
\n                new TeamSiteDataContext(
\n                    new Uri(\"http:\/\/intranet.contoso.com\/_vti_bin\/listdata.svc\"));
\n            dc.Credentials = CredentialCache.DefaultNetworkCredentials;
\n            var query =
\n                from c in dc.Customers
\n                where c.CustomerID == customerID
\n                select new Customer()
\n                {
\n                    CustomerID = c.CustomerID,
\n                    CustomerName = c.CustomerName,
\n                    Age = (int)c.Age,
\n                };
\n            var customerToDelete = query.FirstOrDefault();
\n            dc.DeleteObject(customerToDelete);
\n            dc.SaveChanges();<\/p>\n

        }<\/p>\n

        public static void CreateCustomer(Customer customer,
\n            out Customer returnedCustomer)
\n        {
\n            \/\/ create item
\n            TeamSiteDataContext dc =
\n                new TeamSiteDataContext(
\n                    new Uri(\"http:\/\/intranet.contoso.com\/_vti_bin\/listdata.svc\"));
\n            dc.Credentials = CredentialCache.DefaultNetworkCredentials;
\n            CustomersItem newCustomer = new CustomersItem();
\n            newCustomer.CustomerID = customer.CustomerID;
\n            newCustomer.CustomerName = customer.CustomerName;
\n            newCustomer.Age = customer.Age;
\n            dc.AddToCustomers(newCustomer);
\n            dc.SaveChanges();
\n            returnedCustomer = customer;
\n        }
\n    }
\n}
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

Create a .NET assembly connector that creates an ECT that consumes an OData feed.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"categories":[16,4],"tags":[],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-bcs","category-sharepoint"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=415"}],"version-history":[{"count":4,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/415\/revisions"}],"predecessor-version":[{"id":7316,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/415\/revisions\/7316"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/categories?post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/tags?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}