SilverlightShow: Windows Phone 7.5 - Local SQL Database Comments http://www.silverlightshow.net/ Silverlight articles, Silverlight tutorials, Silverlight videos, Silverlight samples SilverlightShow.net http://www.rssboard.org/rss-specification Argotic Syndication Framework 2008.0.2.0, http://www.codeplex.com/Argotic en-US estoychev@completit.com (Emil Stoychev) Re: Windows Phone 7.5 - Local SQL Database <p>Sorry am getting this </p> <p>An overflow occurred while converting to datetime. </p> <p> </p> <p>How can i fix this. </p> <p>Urgent Thanks</p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment9451 akindroid http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Sun, 02 Jun 2013 02:53:47 GMT Re: Windows Phone 7.5 - Local SQL Database Here is a database compatible with Windows Phone 8:<br /> <a target="_blank" title="You are about to go to a URL outside odesk.com" href="https://www.odesk.com/leaving-odesk?ref=https%253A%252F%252Fwww.kellermansoftware.com%252Fp-49-ninja-winrt-database.aspx">https://www.kellermansoftware.com/p-49-ninja-winrt-database.aspx</a><br /> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment9051 http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Tue, 12 Mar 2013 21:35:14 GMT Re: Windows Phone 7.5 - Local SQL Database Thanks for the suggestions! Bye. http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7842 AndreaBoschin http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Mon, 16 Apr 2012 00:53:42 GMT Re: Windows Phone 7.5 - Local SQL Database Nice work as usual. I have changed the DateTime properties of the objects to nullable type to avoid runtime errors. HTH http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7841 dvernole http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Sun, 15 Apr 2012 21:03:34 GMT Re: Windows Phone 7.5 - Local SQL Database <p>hi,</p> <p>My sql is at the visual studio 2010 , I create it there.</p> <p>How can i connect my sql to the code that you write, it doesn't work, i can't see the things that i add to the data base, the data base is empty .</p> <p>please help me!</p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7757 ShaniBaruch http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Mon, 02 Apr 2012 13:57:44 GMT Re: Windows Phone 7.5 - Local SQL Database <p>hi,</p> <p>My sql is at the visual studio 2010 , I create it there.</p> <p>How can i connect my sql to the code that you write, it doesn't work, i can't see the things that i add to the data base, the data base is empty .</p> <p>please help me!</p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7756 ShaniBaruch http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Mon, 02 Apr 2012 13:04:55 GMT Re: Windows Phone 7.5 - Local SQL Database <p>Tengo un ERROR al ejecutar la aplicación, me manda un erro de desbordamiento al convertir el datetime, Porque pasa eso?</p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7492 MarcoAntonioAguilar http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Sun, 05 Feb 2012 18:54:21 GMT Re: Windows Phone 7.5 - Local SQL Database <p>I think I got it, when inserting test data:</p> <p>InsertOnSubmit was not informing DateLastUpdate</p> <p>That was why it was crashing, mmm... maybe no default value leads to that crash? (or maybe just set that value to nullable?)</p> <p>Cheers</p> <p>  Braulio</p> <span style="font-family: consolas; font-size: 13px;"> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </span> <p> </p> <p><span style="color: #2b91af; font-family: consolas; font-size: 13px;">DateTime</span><span style="font-family: consolas; font-size: 13px;">.Now</span></p> <p><span style="font-family: consolas; font-size: 13px;"></span> </p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7168 brauliodiez http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Mon, 07 Nov 2011 13:18:54 GMT Re: Windows Phone 7.5 - Local SQL Database <p>Very good stuff Andrea !!!</p> <p>Very well written article, about the sample good guidance.</p> <p>Just one thing I download the sample as is and got an exception when launching it (DateTime overflow exception), I will take a look.</p> <p>For newcomers, maybe it would be worth to first read (<a href="http://devlicio.us/blogs/derik_whittaker/archive/2011/07/21/using-sql-ce-on-wp7-mango-getting-started.aspx">http://devlicio.us/blogs/derik_whittaker/archive/2011/07/21/using-sql-ce-on-wp7-mango-getting-started.aspx</a>) then jump into this comple and great article from Andrea.</p> http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment7167 brauliodiez http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Mon, 07 Nov 2011 13:07:43 GMT Re: Windows Phone 7.1 - Local SQL Database Great post  !! Thanks for your sharing  !! http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx#comment6618 SaadHaffar http://www.silverlightshow.net/items/Windows-Phone-7.1-Local-SQL-Database.aspx Sun, 09 Oct 2011 19:47:13 GMT