SQL script for created VIEW in database wrong?

SQL script for created VIEW in database wrong?

Postby Peter Kuhn » Wed 06 Jul 2011 15:24


I created a simple database (SQLite) with a Table and a View. For the View I used the following script:
Code: Select all
SELECT ID, Name FROM Product

If I import my database, I can see the table and the view in the “Database Explorer” which is separated in two categories:
Database Connection --> main --> Tables --> Product
Database Connection --> main --> Views --> ProductSlim

If I try the function “Generate Database Script From Model” I see that my View is converted to a table:
Code: Select all
-- Creating a table "main".ProductSlim
CREATE TABLE "main".ProductSlim (
   Name TEXT

Is there any possibility to avoid this conversion?

Peter Kuhn
Peter Kuhn
Posts: 1
Joined: Wed 06 Jul 2011 15:01

Postby AndreyR » Thu 07 Jul 2011 09:37

Unfortunately, the model does not contain the information that is necessary for the view script generation (namely, we don't have any information about the table(s) the SELECT statement is applied to).
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to LinqConnect (LINQ to SQL support)