Category: .NET

NServiceBus is similar to BizTalk. BizTalk is a message broker. NServiceBus is a message bus. It implements the bus architecture where backend systems have the infrastructure to process messages. Internally, NServiceBus uses MSMQ for receiving messages and RavenDB for scalability and transactions.

There are two types of message processing: Commands and Events. Command messages are sent to endpoints. Applications listening at the endpoint process the messages. …

Read More

SQLite is an open-source SQL database engine. It is widely used in iOS apps. The database is available in the form of a file.

Create Database

To create a database with name accounting:

sqlite3 accounting.sqlite

.tables is a command which lists all tables. Add a new table, Company. And insert a few rows.

CREATE TABLE company 
(id int, seats int);
INSERT INTO company (id, seats)
VALUES (1, 20);
INSERT INTO company (id, seats)
VALUES (2, 30);
INSERT INTO company (id, seats)
VALUES (3, 50);

ALTER TABLE has restricted syntax.…

Read More

Microsoft FAST Search for SharePoint provides enterprise search and information retrieval capabilities. FAST provides a API to query documents indexed in the server. The API is available in a proprietary assembly, Esp-SearchApi.

We will write a simple program to perform a search. We use the following namespaces.

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Linq;
using System.Text;
using Com.FastSearch.Esp.Search.Http;
using Com.FastSearch.Esp.Search.Result;
…
Read More

Entity Framework is an ORM layer for .NET applications. Sometimes, we import data from a flat file. Technically, this boils down to: Delete all records from the table. And insert new records into the table.

Import data

Below is the first cut of code that I wrote. A logical use of Entity framework. But unexpectedly, yields very poor performance.

// delete data
foreach(Employee emp in context.Employees)
…
Read More

ASP.NET Web API is the framework for creating HTTP services or RESTful services in the Microsoft platform. It super-cedes the WCF framework. Browsers in desktops, tablets or mobiles can access the Web API.

Comment API

In this post, we create a Web API for Comments. Create a new MVC application. Create a controller called CommentController. It is an API controller with CRUD methods and integrates with Entity Framework.…

Read More

A data-tier application (.dacpac) creates or updates database schema for SQL Server. Usually, database administrators deploy the application in SQL Server using Management Studio (SSMS). Sometimes, we have to deploy the application programatically. This post explains how to deploy a data-tier application to SQL Azure using .NET.

While deploying using a program, we use a background task, typically a worker role in Azure.…

Read More