Compact Framework and Views

Posts   
 
    
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 30-Dec-2007 03:56:42   

Does the compact framework support views using sql mobile 2005?

Have created a CF app which uses views with llblgen code but get an error. Appears the view is not on the sdf file but it is in the sql 2005 server databse.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 30-Dec-2007 12:04:07   

1) if you get an error, state exactly what the error is, with exception name/stacktrace 2) http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7718

I've to lookup what the exact features are of sqlserver mobile version x.y. if the views aren't in the sdf file, it's hard to fetch them at runtime I think wink

Frans Bouma | Lead developer LLBLGen Pro
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 30-Dec-2007 23:52:46   

yep..appears that mobile 2005 does not support views. Can you create virtual joins in llblgen?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 31-Dec-2007 05:31:55   

Hi Anthony,

What exactly you meant? You can use TypedLists and DynamicList as well.

David Elizondo | LLBLGen Support Team
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 05-Jan-2008 05:45:29   

thanks..using dynamiclist to achieve it