June 10th, 2013

C# LINQ: Saving JSON Data to SQL Server Database using JSON.NET and SqlBulkCopy

In this post, we will add JSON data to Sql Server tables using ASP.NET Web API, JSON.NET and SqlBulkCopy. The data is posted using jQuery ajax to web api which accepts JObject type argument, parse data, arrange data in the required table structure and save to database. Here is the structure of JSON and SQL Server tables.
Read More C# LINQ: Saving JSON Data to SQL Server Database using JSON.NET and SqlBulkCopy

June 2nd, 2013

Facebook Style Wall Posts and Comments using Knockout.js and ASP.NET Web API

In this article, we will implement Facebook style wall posting with following features using Knockout.js, jQuery and ASP.NET MVC 4 with Web API.

1. Add new post and display the latest post first
2. Add new comment to post
3. Display date time in fuzzy time stamps (e.g. 5 mins ago..)
4. Auto-grow textarea for long posting and commenting
5. Comment link to toggle comment box
6. Display user avatar for posts and comments
Read More Facebook Style Wall Posts and Comments using Knockout.js and ASP.NET Web API

May 18th, 2013

CRUD Operations using jQuery Dialog with WYSIWYG HTML Editor, Knockout and ASP.NET Web API

In this article, We will implement CRUD (Create, Read, update and delete) operations with Knockout.js, ASP.NET Web API, Entity Framework 5.0 Database First Approach. For Add or Edit operation, A modal dialog having WYSIWYG Html editor is used. User can enter information and submit it. It should look like the image below:
Read More CRUD Operations using jQuery Dialog with WYSIWYG HTML Editor, Knockout and ASP.NET Web API

January 26th, 2013

Using Microsoft Translator With ASP.NET MVC 4 Web API

This article explains how to use the Microsoft Translator API to translate text that was input by the user. Microsoft Translation Service is an online service which has support for AJAX, HTTP or SOAP and Basic subscriptions, up to 2 million characters a month, are free. Google’s free Translation API are deprecated So Microsoft Translator is a good alternative. In this sample, we will use AJAX API for English to Hindi translation. Read More Using Microsoft Translator With ASP.NET MVC 4 Web API

January 13th, 2013

Database Change Notifications in ASP.NET using SignalR and SqlDependency

This article shows how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object which represents a query notification dependency between an application and an instance of SQL Server. Consider your database is updated or synchronized by windows service in background, you have to display real time updated data. This article explains how to implement it.
Read More Database Change Notifications in ASP.NET using SignalR and SqlDependency

December 14th, 2012

HTTP PATCH Requests (Partial Updates) in ASP.NET Web API and EF DB First

To update an entity in ASP.NET Web API, PUT request is used and we have to send all the properties even if only a subset have changed means if only one field is updated on the client side, we have to send the entire model back to the server to make an update. It’s not a cool way. PATCH request allows you to send just the modified properties for partial model updates. It reduces complexity in case of bigger tables. Here is a usage example to implement HTTP Patch request in ASP.NET Web API to update data with EF DB First. Read More HTTP PATCH Requests (Partial Updates) in ASP.NET Web API and EF DB First

December 1st, 2012

Fast Downloading with Parallel Requests using ASP.NET Web API

In this article, we will implement to download parts of file in parallel to get the complete file faster. It is very useful to download large file and saves a bunch of time. ASP.NET Web API supports byte range requests(available in latest nightly build) with ByteRangeStreamContent class. We will request the ranges of file parts in parallel and merge them back into a single file. Read More Fast Downloading with Parallel Requests using ASP.NET Web API