tag:blogger.com,1999:blog-1889802892159956072.post2047328350168658869..comments2023-07-04T12:08:27.486+03:00Comments on Claudiu Farcas Blog: Windows Phone Mango SQL CE tips and tricksClaudiu Farcashttp://www.blogger.com/profile/17978997978295686914noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1889802892159956072.post-85532760951839029452011-10-24T00:41:02.420+03:002011-10-24T00:41:02.420+03:00Ok.. so the trick is to create another project of...Ok.. so the trick is to create another project of type Console, Winform, Library etc. where you can create a SQL CE 3.5 "Local Database". . then after, you copy this new created file into Windows Phone project.<br />After, you have to create a connection to this file into Server Explorer - Data Connection (make sure you use Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)).<br />After, from SQL Server Compact Toolbox (and having Windows Phone project selected into Solution Explorer) right click on the Database file and choose "Add Windows Phone DataContext to current Project ..." option.<br />This should launch the datacontext creation wizard.<br /><br />Well done!<br />Nice tool Erik! ;)Claudiu Farcashttps://www.blogger.com/profile/17978997978295686914noreply@blogger.comtag:blogger.com,1999:blog-1889802892159956072.post-50518536946746827992011-10-23T21:04:59.242+03:002011-10-23T21:04:59.242+03:00Indeed Erik, SQL Server Compact Toolbox is a great...Indeed Erik, SQL Server Compact Toolbox is a great tool.<br /><br />I'm testing generating the DataContext for a Windows Phone project/library and it seems I have to find some tricks to make it work. Any ideas!?<br /><br />Regards,<br />Claudiu FarcasClaudiu Farcashttps://www.blogger.com/profile/17978997978295686914noreply@blogger.comtag:blogger.com,1999:blog-1889802892159956072.post-65268978169095301402011-10-23T19:48:26.227+03:002011-10-23T19:48:26.227+03:00I suggest you have a look a SQL Server Compact Too...I suggest you have a look a SQL Server Compact Toolbox, which can create an improved DataContext, with Indexes and Foreign KeysErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.com