Answered by:
Create the equilavent of a view within EDM when using Compact SQL?

Question
-
I'm using Visual Studio 2010, am new to C#. A friend of mine suggested that I use Compact SQL, and connect it to my solution with EDM. I'm new to both of these as well.
Within the Compact SQL db, I have three tables that I want to join and create the equivalent of a view. Compact SQL doesn't support Views, and I'm not finding a way to construct the equivalent within the EDM.
Is it possible? Recommended reading?
- Edited by JamesA-CHI Monday, July 8, 2013 1:20 AM
- Moved by Bob Shen Wednesday, July 10, 2013 4:16 AM
Monday, July 8, 2013 1:20 AM
Answers
-
Ask here...
SQL Server Compact forum: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlce
Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, July 16, 2013 7:48 PM
- Marked as answer by Just Karl Tuesday, July 23, 2013 6:58 PM
Tuesday, July 16, 2013 7:48 PM
All replies
-
Hi JArthurs,
Would you mind clarify this issue more clearly please? Thanks.
Bob Shen
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.Tuesday, July 9, 2013 5:24 AM -
I'm not sure I can, but I'll try.
I'm using Compact SQL. If compact SQL allowed the creation of Views, they would be available through the EDM. Correct?
Since Compact SQL doesn't allow for views. Is there a way to do multiple joins with fields calculated using a SQL CASE like statement, within EDM?
Tuesday, July 9, 2013 6:04 AM -
Hi JArthurs,
I’m afraid that C# forum is not the best forum about this issue. I am moving your question to the moderator forum ("Where is the forum for..?"). The owner of the forum will direct you to a right forum. Thanks for your understanding.
Bob Shen
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.Wednesday, July 10, 2013 4:16 AM -
Ask here...
SQL Server Compact forum: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlce
Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, July 16, 2013 7:48 PM
- Marked as answer by Just Karl Tuesday, July 23, 2013 6:58 PM
Tuesday, July 16, 2013 7:48 PM