- \n
- There is a Business Data Connectivity service up and running on the SharePoint farm for the External Content Type (ECT) to be deployed to.<\/li>\n
- The user deploying the solutions containing the ECT, in this case the user running Visual Studio, has adequate permissions to create it in the application service.<\/li>\n
- This is just a demonstration, so there will be a distinct lack of logging, error handling and bad practices such as storing database credentials in plain text within the code, try to ignore this \ud83d\ude42<\/li>\n<\/ul>\n
<\/p>\n
OK, let’s get going.<\/p>\n
Open Visual Studio and either load your existing SharePoint project or create a new one.<\/p>\n
The first thing we need to do is create the Business Data Connectivity Model, so go ahead and add one to your project.<\/p>\n
![\"Add](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AddNewBDCModel.png\")
<\/a>Add new BDC Model<\/p><\/div>\n
Which will show something very similar to the following screenshot:
\n![\"Initial](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/InitialBDCModelDiagram.png\")
<\/a>Initial BDC Model Diagram<\/p><\/div><\/p>\n
It easier to start with a clean slate, so delete the existing entity from the diagram.<\/p>\n
![\"Delete](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/DeleteEntity1.png\")
<\/a>Delete Entity1<\/p><\/div>\n
In the Solution Explorer pane, delete the Entity1 and Entity1Service classes.<\/p>\n
![\"Delete](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/DeleteEntity1Classes.png\")
<\/a>Delete Entity1 Classes<\/p><\/div>\n
Back in the Model, add a new entity.<\/p>\n
![\"Add](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AddNewEntity.png\")
<\/a>Add New Entity<\/p><\/div>\n
Next, rename it to CustomerOrders.<\/p>\n
![\"Rename](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/RenameNewEntity.png\")
<\/a>Rename New Entity<\/p><\/div>\n
Note the new service class that was automatically created for you.<\/p>\n
![\"New](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/NewCustomerOrderServiceClass.png\")
<\/a>New Customer Order Service Class<\/p><\/div>\n
There are a couple of requirements for all external content types. These stipulate that there must be a method for retrieving a single item and another for retrieving a collection of items. We’ll start with the multiple items method. In the BDC Method Details<\/em> pane, expand the Add a Method<\/em> drop down and select Create Finder Method<\/em><\/p>\n
![\"Create](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/CreateFinderMethod.png\")
<\/a>Create Finder Method<\/p><\/div>\n
This will add a method called ReadList<\/em> to the CustomerOrders entity.<\/p>\n
All entities require at least on identifier, so to create one right click on the entity in the diagram and select Add new Identifier<\/em>.<\/p>\n
![\"Add](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AddNewIdentifier.png\")
<\/a>Add New Identifier<\/p><\/div>\n
In this example, the identifier is called OrderId<\/em>.<\/p>\n
To update this, select the new identifier in the entity and change the name and type to OrderId<\/em> and System.Int32<\/em>, which corresponds to the primary key field in the database.<\/p>\n
![\"Rename](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/RenameIdentifierAndSetType.png\")
<\/a>Rename Identifier and Set Type<\/p><\/div>\n
While adding the new entity to the model, a service class was automatically created for you. We also require a class to define the fields we want used by the external content type. Add a new class to the project called CustomerOrderEntity<\/em>.<\/p>\n
![\"Add](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AddCustomerOrderEntityClass.png\")
<\/a>Add Customer Order Entity Class<\/p><\/div>\n
Update the class with the following code:<\/p>\n
\r\npublic partial class CustomerOrderEntity\r\n{\r\n public int OrderId { get; set; }\r\n\r\n public int CustomerId { get; set; }\r\n\r\n public string Title { get; set; }\r\n\r\n public string Forename { get; set; }\r\n\r\n public string Surname { get; set; }\r\n\r\n public string Town { get; set; }\r\n\r\n public string ItemTitle { get; set; }\r\n\r\n public decimal Cost { get; set; }\r\n}\r\n<\/pre>\nThese map directly to the database view columns that will drive the content.<\/p>\n
Back in the model, open the BDC Explorer<\/em> pane and navigate down to the CustomerOrders<\/em> node within ReadList<\/em>.<\/p>\n
From there, right click it and add a new type descriptor.<\/p>\n
![\"Add](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AddTypeDescriptor.png\")
<\/a>Add Type Descriptor<\/p><\/div>\n
The new type descriptor is going to map to the first property in the customer order entity class that you just created.<\/p>\n
To do this, select the new type descriptor in the BDC Explorer pane and in the Properties pane update it so the Name<\/em> is OrderId<\/em> and the Type Name<\/em> is System.Int32<\/em>.<\/p>\n
![\"OrderId](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/OrderIdTypeDescriptor.png\")
<\/a>OrderId Type Descriptor<\/p><\/div>\n
Repeat this process for the remaining properties.<\/p>\n
![\"All](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AllTypeDescriptors.png\")
<\/a>All Type Descriptors<\/p><\/div>\n
With the type descriptors in place, we need to let the model know which one maps to the identifier the was added to the entity. To do this, select OrderId<\/em> in the BDC Explorer pane and in the Properties pane for it set the Identifier Entity<\/em> to CustomerOrders<\/em>.<\/p>\n
![\"Set](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/SetOrderByIdIdentifierEntity.png\")
<\/a>Set OrderId Identifier Entity<\/p><\/div>\n
Next, set the Identifier<\/em> property to OrderId<\/em>.<\/p>\n
![\"Set](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/SetOrderIdIdentifier.png\")
<\/a>Set OrderId Identifier<\/p><\/div>\n
To complete the ReadList<\/em> configuration, select the CustomerOrders<\/em> node. In the Properties pane, open the drop down for the Type Name<\/em> property, change to the current project tab and select the item titled CustomerOrderEntity<\/em>. This is the class you added previously and tells the model what type of object to expect this node to process.<\/p>\n
With the first finder method almost complete, we’ll now add the specific finder method to allow single items to be retrieved.<\/p>\n
As before, expand the Add a Method<\/em> drop down in the BDC Method Details pane, this time selecting Create Specific Finder Method<\/em>.<\/p>\n
![\"Create](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/CreateFinderMethod1.png\")
<\/a>Create Finder Method<\/p><\/div>\n
After doing this, all the type descriptors you manually created for the ReadList method will be automatically add to the new finder method for you.<\/p>\n
![\"All](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/AllTypeDescriptors_BothMethods1.png\")
<\/a>All Type Descriptors<\/p><\/div>\n
Now onto the parameters for the two new methods that you just created.<\/p>\n
Starting with ReadList<\/em>, highlight the row in the BDC Method Details pane where the direction type is return, clicking on the Type Descriptor<\/em> column.<\/p>\n
The type name for this is currently set incorrectly and needs to map to the customer order entity class that was manually added to the project.<\/p>\n
To do this, open the drop down list for Type Name<\/em> in the properties pane, select the tab for the current project and select the CustomerOrderEntity<\/em> item.<\/p>\n
![\"Set](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/SetTypeNameForReadListReturnParameter.png\")
<\/a>Set Type Name for ReadList Return Parameter<\/p><\/div>\n
Do the exact same for the ReadItem<\/em> method.<\/p>\n
![\"Set](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/SetTypeNameForReadItemReturnParameter.png\")
<\/a>Set Type Name for ReadItem Return Parameter<\/p><\/div>\n
That should be the model complete, at least as far as this demonstration is concerned. You’ll be able to follow similar steps to add filters that allow you to limit the number of items returned, for example.<\/p>\n
If you take a look at the CustomerOrderService class you’ll see a couple of methods have already been added, each one mapping to the finder method that you added via the model diagram.<\/p>\n
\r\npublic static IEnumerable
ReadList()\r\n{\r\n throw new System.NotImplementedException();\r\n}\r\n \r\npublic static string ReadItem(int orderId)\r\n{\r\n throw new System.NotImplementedException();\r\n}\r\n<\/pre>\n As mentioned at the start of this post, the purpose of this is to provide a walk through on creating a simple external content type, so I won’t go into the implementation of these methods in detail, although, if you’re interested in seeing this up and running I have provided the full source code for the sample. You’ll find a link for this at the end of this post.<\/p>\n
The code that should replace the above is:<\/p>\n
\r\npublic static IEnumerable
ReadList()\r\n{\r\n IEnumerable orderEntities;\r\n\r\n using (var dbEntities = new DemoDbModelDataContext(GetConnectionString()))\r\n {\r\n IList orderRecords = (from customerOrder in dbEntities.vCustomerOrders\r\n select customerOrder).ToList();\r\n\r\n orderEntities = from record in orderRecords\r\n select ConvertToCustomerOrderEntity(record);\r\n }\r\n\r\n return orderEntities;\r\n}\r\n\r\npublic static CustomerOrderEntity ReadItem(int orderId)\r\n{\r\n using (var dbEntities = new DemoDbModelDataContext(GetConnectionString()))\r\n {\r\n vCustomerOrder customerOrderRecord = GetCustomerOrderByOrderId(dbEntities, orderId);\r\n\r\n CustomerOrderEntity orderEntity = ConvertToCustomerOrderEntity(customerOrderRecord);\r\n\r\n return orderEntity;\r\n }\r\n}\r\n\r\nprivate static readonly Func Which you can see uses the LINQ to SQL data model to access the SQL data and transforms the result to the types the BDC model expects.<\/p>\n
Deploying<\/strong><\/p>\n
Once all the SQL code has been wired up, go ahead and deploy the solution.<\/p>\n
Once deployed, the farm scoped feature will automatically activate and create the external content type in Central Administration for the BDC service that is defined for the current web application.<\/p>\n
![\"Deployed](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/DeployedECT.png\")
<\/a>Deployed ECT<\/p><\/div>\n
Drilling into the content type you can see the fields that are available.<\/p>\n
![\"ECT](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/ECT_ItemDefinition.png\")
<\/a>ECT Item Definition<\/p><\/div>\n
In a site collection for the same web application, create a new external list and associate the external content type with it. Viewing the list should present you something like the following:<\/p>\n
![\"ECT](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/ECTViewResults.png\")
<\/a>ECT View Results<\/p><\/div>\n
For a single item:<\/p>\n
![\"ECT](\"http:\/\/www.stuartroberts.net\/wp-content\/uploads\/2013\/08\/ECTViewItem.png\")
<\/a>ECT View Item<\/p><\/div>\n
Code<\/strong>
\nTo download the code and database schema for this walk through, click on the following link<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"Looking to design your own external content type and deploy it as part of a SharePoint solution? Read on for a walkthrough on how to create one. First up, the steps are the same for SharePoint 2010 and 2013 and … Continue reading