Last post Jul 11, 2006 01:47 PM by phuff
Jul 11, 2006 09:54 AM|mhenke|LINK
When you point BLINQ to a DB do you have the Option or some config file to specify what Tables/Columns you want to perform SELECT, INSERT, UPDATE and DELETE opetaion on or does it automatically include all Tables and Relationships in the DB. Also how does
the Model Update itself if you Change the DB Schema? Does it Detect changes or do yuo have to change the BLINQ Option or Config as I mentioned earlier?
Jul 11, 2006 01:47 PM|phuff|LINK
Blinq doesn't support choosing which tables and columns should be included. It includes all tables and all columns that the GridView can render (it can't render binary object columns, for instance). However, you can delete pages for tables you don't want
to render. You can remove columns from the GridView that you don't want to display. The Readme.rtf file located in \Program Files\Microsoft ASP.NET\Blinq explains how to change a field's update mode, which you will need to do if you delete a column that
participated in optimistic concurrency.
Blinq is a one-time website generation tool, so once it runs it doesn't go back and look at your database schema. You can always rerun Blinq to create a new website, but it won't merge changes in with your existing changes. You can use a tool like diff
or windiff to manually merge changes into your existing site if your schema changes; the changes should be relatively small.
Both of these are options we are considering supporting for the next version of Visual Studio.
Hope this helps.