c# - creating a backend data storage for quick retrieval -
i writing software stores information of users interaction in global session object/class. store values collected in persistent storage. cannot use heavy databases such sql server or mysql in target pc need keep installer minimum in size.
i need retrieve values storage passing simple linq queries,etc.
my question next best thing databases can manipulated c# code?
probably either sqlite or sql server compact edition - these both full-featured database systems run entirely in-process , used these sorts of thing (for example firefox uses sqlite store bookmarks).
the next rung down ladder of complexity either xml (using linq xml), or serialisable objects (using linq objects) - of course incur performance penalties on "proper" compact database sqlite if started storing lot of data, need store more think before became noticable, , small data sets simplicity make faster sqlite (for example restrict application storing last 100 or actions).
Comments
Post a Comment