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
Author: rocker8942
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
Javascript to use in 2016
Use AngularJS, React, D3, Polymer and Ionic and throw away backbone, knockout, ember, jQuery.
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
SQL Server remote access
To make Sql Server to be accessed remotely, check the belows. 1. Use correct server name. The server name is machine name + instance name. e.g. My-PC\SQLExpress The server name shouldn’t start with ‘\\’ 2. Tick Allow remote connection to this server from the tab Connection of Server Property from SQL Server Management Studio. 3. Enable TCP/IP… Continue reading SQL Server remote access