Lightswitch views

[sellingerd]

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]

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.