Jim
Jim

Reputation: 423

Accessing SQL metadata in LightSwitch

I am trying to access extended properties in my SQL database in LightSwitch. Ideally I would be able to populate a choicelist based on these extended properties - namely picklist values.

Is there any way in which I can do this?

Any help would be much appreciated.

Cheers

Jimmy

Upvotes: 2

Views: 147

Answers (2)

Cade Roux
Cade Roux

Reputation: 89661

Expose the extended properties from SQL Server with a view or stored proc and then access it like regular application data.

Try this bundle of links which accompany my presentation on metadata: https://bitly.com/bundles/caderoux/3

Upvotes: 1

Michael Washington
Michael Washington

Reputation: 3075

WCF RIA Service is always your answer. You can do anything.

Upvotes: 0

Related Questions