How Do You Populate a SharePoint List Difinition from MS SQL Server Table?

I created a SharePoint List Definition project in Visual Studio 2010 and published the solution to a SharePoint site.  How do you populate the List Definition from a MS SQL Server Table?  Do you know of some examples?

Thanks,

Dan
danielolorenzAsked:
Who is Participating?
 
zabiullahConnect With a Mentor Commented:
You can use

1) BCS(Business Connectivity Services - External List/Content Types) - *External List is not stored in the SharePoint 2010 content database.
Reference:
- http://www.sswug.org/articles/viewarticle.aspx?id=47401
- http://www.mstechblogs.com/sharepoint/how-to-step-by-step-creation-of-external-list-in-sharepoint-2010/

2) SSIS (Microsoft SQL Server Integration Services) & SharePoint List Source and Destination Adapter project on Codeplex
Reference:
- http://www.petestilgoe.com/2011/01/populate-a-sharepoint-list-from-an-sql-database/
- http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

HTH,
- Zabi
0
 
danielolorenzAuthor Commented:
Zabi,

Excellent help.  I am required to load the SharePoint List Definition using Visual Studio and making the MS SQL Server connection there.  Do you know how to load the list definition using Visual Studio to SQL connection?

Thanks,

Dan
0
 
danielolorenzAuthor Commented:
Excellent Help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.