SharePoint Feature and Package Designers in Visual Studio 2010

This time I interview a good friend of mine, Boris Scholl, a Program Manager on the Visual Studio Team building tools for SharePoint development. Boris shows off the new Business Data Connectivity designer in Visual Studio 2010 and how it allows you to describe data coming from multiple data sources and how to work with them in SharePoint. He builds a master/detail association across entities coming from separate data sources (a database and a service) and demonstrates how the entities can be displayed and edited.
For more information on SharePoint Development in Visual Studio 2010 please see:
Also if you missed them, check out these interviews as well:
And please
give us your feedback in the SharePoint Development Forums!
Enjoy,
-Beth Massi, Visual Studio Community
Hey Now Beth,
Nice Vid, learned a lot.
Thx 4 the info,
Catto
Thank you for the tutorial... but I get the following Error:
Error 1 Error occurred in deployment step 'Add Solution':
There is no default Business Data Connectivity Service Proxy available for the given SPServiceContext.
Any help?
Thanks
Hi, which SharePoint version are you using?
Thanks,
Boris
Hi, I get the following error when i add the external list to sharepoint
Error while executing web part: System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString conne
I've searched the internat for possible solutions, but nothing that i've read has solved my problem. Which included increasing the number of recs to read, changing SQl authentication to mixed.
thks
Faizel
Hi Faizel,
The error message usually occurs when you are using Windows Authentication and the SQL Server instance is on different computer. Ensure that the account being used to access SQL Server is a domain account. If the account being used is a local account on the client computer, then this error message occurs because the SQL Server and the Domain Controller cannot recognize a local account on a different machine.
If you use SQL Server authentication make sure that that the SQL Server login exists.
Thanks,
Boris
Excellent - just what I wanted to learn.
After following instructions for setting up SharePoint 2010 on Windows 7, following the first BDC Project instructions and following the blog entry about Fearure Event Receiver, I get 500 - Internal Server Error at the "Adding Solution" step of deployment process (in your video, when you press F5). Any suggestions?
These are the references I followed:
http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx">http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx
https://code.msdn.microsoft.com/BDCSPFoundation
Thanks, great introduction to creating a BDC in Visual Studio .
I hope it has given me enough to get one created.
Must admit that some follow up demostrations of the following would be great:
Hi
I running a BCS solution in sharepoint 2010 web site, the readitem, readlist, create and delete operations work but the update operation has a problem throwing the following exception: Microsoft.SharePoint.WebPartPages.DataFormWebPartException: Data Source Conflict: Your changes conflict with those made concurrently by another user.
I don't know what is wrong
Any help
Julian
Hi Julian,
Make sure all the fields in the update method's parameter have updaterField set to True.
Cheers,
Vamshi
Excellent - just what I wanted to learn.
After following instructions for setting up SharePoint 2010 on Windows 7, following the first BDC Project instructions and following the blog entry about Fearure Event Receiver, I get 500 - Internal Server Error at the "Adding Solution" step of deployment process (in your video, when you press F5). Any suggestions?
These are the references I followed:
http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx">http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx
Try this post, this guy is brilliant!! http://www.gabrielrenom.net
Hi Vamshi,
Do you know of your suggestion solved Julian's problem? I'm having the same problem but even through I've verified that Updater Field is set for all properties in my Update parameter, I'm still getting the same error.
Could you please let me know if there's another source of this error? I'm really stuck on this!
Thanks,
KBW
Is the code/demo available for the NortwindEnities service (svc) that Boris connects to?
Ok it looks like I do not need to create my own as there one on the web http://services.odata.org/Northwind/Northwind.svc/.
Next problem is that Boris has a table called EmpWorkSpace and my Northwind does not!
Where does the EmpWorkSpace come from?