Lightswitch Datasource views missing from list

Question

I just started using Lightswitch 2013 and I have created a new view in my SQL Server 2012 database but cannot see it in Lightswitch when I go to refresh the datasource. Do I have to refresh some sort of cache or something?

ALTER VIEW viw_Months 
AS 
     SELECT DISTINCT MonthKey, MonthName FROM dbo.dim_Time

The Dim.Time table has a primary key on the DateID field.

Does the connecting user have rights to the object? – Nick.Mc May 01 '14 at 05:30 — Nick.Mc, May 01 '14 at 05:30

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

Maybe the problem was your view doesn't have candidate column to be primary key :

LightSwitch must be able to infer a primary key for the view so that one row can be distringuished from another. If all of the view's columns are nullable then a primary key cannot be inferred and LightSwitch will not let you select it to be imported.

[social.msdn.microsoft.com : update datasource -> a particular view does not show up in list to add it to project]

Related SO Question : How do I get MS LightSwitch to recognize my View?

edited Jun 20 '20 at 09:12

Community

1
1

answered May 01 '14 at 05:29

har07

88,338
12
84
137

THANKYOU! Thats a bit tricky, should tell you after you click Update. – Ben McLean May 01 '14 at 06:19

Lightswitch Datasource views missing from list

1 Answers1

Linked