SQLite is an open-source SQL database engine. It is widely used in iOS apps. Create SQLite Database SQLite has an executable sqlite3.exe. To create a database with name accounting: Open the command prompt. Execute “sqlite3 accounting.sqlite”. The above command creates
Microsoft FAST Search for SharePoint provides organization with enterprise search and information retrieval capabilities. FAST provides a simple API to query documents index in a FAST server. The FAST Search API is available in Esp-SearchApi assembly. Esp-SearchApi assembly is available for
I want to refresh a table with data from a flat file. Technically, this boils down to: delete all rows from the table, and insert new rows. I have already got a lot of code based on Entity framework. So,
ASP.NET MVC Web API is the way to create HTTP services or RESTful services in the Microsoft platform. It supercedes the WCF REST framework. Web API can be accessed by a wide variety of client applications including browsers in desktops,
I searched the web for a comparision between Entity Framework vs LINQ to SQL. The most popular thread comes from StackOverflow. After going through several such links, I have compiled a few major differences which I am outlining in this post.
A data-tier application (.dacpac) is used to create or update database schema. A data-tier application can be deployed in SQL Azure using SQL Server Management Studio (SSMS). There are some scenarios when a data-tier application needs to be deployed programatically. This
My development environment is WCF 4 / IIS 7.5 / Windows 7 Professional. I have a WCF service with a single operation that sleeps for 2 seconds. My goal is to run 100 concurrent requests and ensure that all the
I have been trying out LINQ to XML for the past few weeks. I am impressed with the improvements in the API made over XML DOM. In this post, I will illustrate a few nice features where LINQ scores over DOM.