Compare to External Lists

Mar 9, 2012 at 2:11 PM

How does this solution compare with the built in External List functionality?

Mar 9, 2012 at 6:17 PM

To use an External List (aka External Content Type) you have to configure the Business Connectivity Service Application. Then you have to define the connector and the desired tables. After that you can use the data in SharePoint via the created External List. The Web Part can be used to integrate the data from a database a lot easier, without to configure and maintenance the BCS.
In addition the current version of the Web Part supports Lookup columns without to connect/configure the foreign key tables separately. The data detail dialog supports different validators, text input formats, regular expressions and custom error messages.

This is the first version of the Web Part. In later versions I'm going to implement support for business rules inside the detail dialog, e. g.: field B is only required when field A is filled....

Mar 9, 2012 at 6:32 PM

Thanks for your response!