Import Model from Database as SQL Queries

Add a BCS model from a database and generates the necessary SQL queries to retrieve and change the data. This recipe will create C# code to retrieve data from the external data source.


Name Description
Model Settings
Name Enter the name of the BCS Model.
Display Name Enter the display name of the BCS Model. This name is visible in dialogs to the user.
Estimated Item Count Enter number of estimated count of elements in the data source.
Is Cached Check if the data should be cached.
Database Settings
Server Enter the name of the database server.
Database Enter the name of the database.
Users Enter all users which should have permission to this model, separated by ';', e.g. 'NT AUTHORITY\Authenticated Users' or 'STS|SecurityTokenService||true|'.


  • Torsten Mandelkow

Version history

  • 1.0 Initial Recipe