Lightswitch views

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
sellingerd
Posts: 1
Joined: Tue 17 Dec 2013 11:50

Lightswitch views

Post by sellingerd » Tue 17 Dec 2013 12:02

I am evaluating dotconnect to create readonly application to read data in a postgress database with lightswitch. I can connect to my database and I see tables okay, but I don't see my view. Is there something special I must do to see views with lightswitch?

I am in lightswitch in visual studio 2012. My table has an integer column and a character varying column (we would consider this column (character varying) to be the primary key if it were possible to create a view with a primary key).

I am new to both lightswitch and dotconnect. I have used postgres with npgsql .net provider extensively.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Lightswitch views

Post by Shalex » Wed 18 Dec 2013 15:54

This view is available in the Choose your Database Objects window:

Code: Select all

CREATE TABLE dept
(
  deptno integer NOT NULL,
  dname character varying(14),
  loc character varying(13),
  CONSTRAINT dept_pkey PRIMARY KEY (deptno)
);

CREATE OR REPLACE VIEW dept_view AS 
 SELECT dept.deptno, 
    dept.dname, 
    dept.loc
   FROM dept;
Please specify the DDL of your view and related tables for reproducing the issue.

Post Reply