BLINQ - DB Schema Questions

Last post 07-11-2006 1:47 PM by phuff. 1 replies.

Sort Posts:

  • BLINQ - DB Schema Questions

    07-11-2006, 9:54 AM
    • Member
      97 point Member
    • mhenke
    • Member since 06-12-2006, 12:05 AM
    • Posts 20

    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? 

  • Re: BLINQ - DB Schema Questions

    07-11-2006, 1:47 PM
    • Contributor
      2,680 point Contributor
    • phuff
    • Member since 06-11-2002, 8:39 AM
    • Redmond, WA
    • Posts 547
    • AspNetTeam

    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.

    Polita Paulus

    This posting is provided "AS IS" with no warranties, and confers no rights.
Page 1 of 1 (2 items)