3

I want to build a new windows phone application that connect with local database, I want to write some complicated SQL to retrieve data.

What is the best to use with Windows phone 8.1, SQL Server Express, SQL Server Compact edition, or SQLite?

Pros and cons please

marc_s
  • 675,133
  • 158
  • 1,253
  • 1,388
Bashar Abu Shamaa
  • 1,828
  • 2
  • 20
  • 33

1 Answers1

2

In case you meant what to use for a local DB on windows phone, Sterling is one of the best options that I have used so far.

bit
  • 4,139
  • 1
  • 25
  • 44
  • Yes, but I want to use some complicated sql, does Sterling will meet that? – Bashar Abu Shamaa Mar 27 '14 at 09:24
  • How much complicated? Check with the codeplex site.. – bit Mar 27 '14 at 10:11
  • Complicated but sqlite work with it – Bashar Abu Shamaa Mar 27 '14 at 10:23
  • 2
    I sure it will work with sterling then :D. To be sure, create a project and test them out before stating the actual work that will also give you a hands on on Sterling! – bit Mar 27 '14 at 10:32
  • After trying several solutions for persistance, I agree that Sterling is really a great solution. Actually it was far easier to set up than the others. And seems like it's faster too, so you should definitely give it a try. – MakanWG Mar 27 '14 at 12:53