Lightswitch views

Lightswitch views

Postby 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.
sellingerd
 
Posts: 1
Joined: Tue 17 Dec 2013 11:50

Re: Lightswitch views

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL