Enabling CRUD for SharePoint 2010 external lists using Visual Studio 2010

  • Article

Recently we published a blog Walkthrough of enabling CRUD for SharePoint 2010 external lists using Visual Studio 2010. This walkthrough shows you how to pull data from an external database into an external list and enable Create, Read, Update and Delete (CRUD) functions to the external list. I copied some paragraphs for your preview.

“In our last blog of this series Walkthrough of creating a SharePoint 2010 external list using Visual Studio 2010 Beta, we introduced how to create a simple “Hello world” external list in SharePoint 2010 Beta using Business Data Connectivity Designer in Visual Studio 2010 Beta.

In this blog, we will show you how to pull data from an external database into an external list and enable Create, Read, Update and Delete (CRUD) functions to the external list.

First of all, you need to have SharePoint 2010 Public and Visual Studio 2010 installed on your machine in order to complete this walkthrough. We’ll use “Northwind” database as external data source, so if you do not have an existing “Northwind” database available, we’ll walk you through to create a local database using SQL Server Express first.

At the end of this post, we will complete with a BDC model project which has a “Customer” entity connects to “Customer” table in “Northwind” database, and have CRUD operations enabled. "