Are there any freeware/shareware examples of Silverlight deskt开发者_StackOverflow中文版op applications with a local SQL backend? I am planning to write a freeware/shareware personal finance application and I'm thinking if whether to do it on Silverlight or WPF.
If you plan on having the SQL backend, you should go with WPF.
Silverlight is restricted in what it can access on the filesystem, even if you run it in the trusted mode and sign the app properly.
People have been implementing all kinds of "good enough" databases that use Isolated Storage. You might use them depending on your level of comfort with the non-mainstream storage engine.
Are you sure you'd need a local SQL database? How much data are we talking about and what is the frequency of inserts/complexity of selects?
For data storage you can use SQL CE4 or even a file based db like SQLite. As rawpower said, I would recommand WPF, too.
There is SQLLite port for Silverlight and Sterling object-oriented database with LINQ support (much better for offline storage).
Both use IsolatedStorage, so no bloat WPF is needed.
Ideal for OOB Silverlight applications.
精彩评论