SQLite in .Net

After using SQLite for a while, a few conclusions that I had were SQLite is quite stable enough to be used in corporate environment. SQLite is faster than SQLCE. For a SQLite admin, use the Firefox addon –  https://addons.mozilla.org/de/firefox/addon/sqlite-manager/ SQL Server Compact Toolbox will be useful: https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1 Both SQLite and SQLCE cannot be used in a… Continue reading SQLite in .Net

CSV Library to use

At first, I used custom built CSV helper class, which simply separates CSV formatted string with a comma and push the data into DataTable. However, this class didn’t handle double quotation qualifier well enough. So, I started searching for a CSV library. One reliable and mostly recommended CSV library was A Fast CSV Reader (aka LumenWorks.Framework.IO) by Sebastien Lorion,… Continue reading CSV Library to use

How to prevent memory leak in WCF

I have one WCF site that I’m managing and it started leaking memory, which ended up consuming up all server memory and stopped working. The change I made between the incident was that I changed from using service reference to using a class called WebServcieClinet that dynamically instantiating the web service connection. The reason why I introduced WebServiceClient… Continue reading How to prevent memory leak in WCF