SQLite in VS 2012

Ok, spent too much time banging my head with this :)

I need to persist small (under 1000) collection of items between sessions on windows without using full database server. Items are simple objects with dozen or so string properties. Database/collection/whatever should be stored in a single file that can be created through code in runtime.

Started with SQL server CE then switched to SQLite but now I'm told Entity is a way to go. I don't mind learning Entity, but seems like too much of an overhead for a simple storage.

What should I do? (if anyone still actually codes windows small databases)

  1. Ditch Entity and access SQLite directly through commands.
  2. Use Entity with SQLite (Would appreciate link on proper way to create databases at runtime tho)
  3. Ditch the whole concept of database (I put this one in because, before, every book had a chapter on databases, now I don't have a single book that mention it. Also not much new stuff on Internet either, so people might moved on to some other concept)

Thanks.

Answers


Sound like structured textual data - dozen or so string properties.

I would use XML

XDocument Class


Need Your Help

Generate PDF/ Microsoft Word Reports using ASP.NET

c# asp.net xslt pdf ms-word

I want to ask for the best way to generate a PDF and Microsoft Word Documents using ASP.NET.

tablerows textviews alignment inside tablelayout

android textview alignment tablelayout tablerow

I have a layout with a TableLayout. I put one TableRow as a header, with 3 TextViews inside.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.