Basics of Web API

Today, Mostly people are using mobile devices in place of web application such as iPhone, mobile phones and tablets in their daily lives. These devices also have many apps to make their life easier like Gmail, Twitter, Facebook etc. In other word we can say web based application is not enough to reach its client. So, if you like to expose your service data to the browsers and as well as all these modern devices apps in fast and simple …

Query optimization in SQL Server

Introduction A query is a request for information from a database. Initially when we have small amount of data everything runs well. Now It has been long time since your team have developed the application. The same query that you were executing earlier was working fine but now it is taking more time. Query optimizer attempts to determine the most efficient way to execute a given query. So in short “Query optimization” is the overall process of choosing the most efficient …

LINQ (The acronym LINQ is for Language Integrated Query) in C Sharp

  What is LINQ? LINQ is a Microsoft programming model and methodology that essentially adds formal query capabilities into Microsoft .Net –based programming languages. It is a component released within the .Net 3.5 framework which is the most powerful feature of .Net. Why LINQ? The popular answer is that LINQ is Integrated with C# (or VB), thereby eliminating the impedance mismatch between programming languages and databases, as well as providing a single querying interface for a multitude of data sources …

XML SERIALIZATION IN C#.NET

SERIALIZATION Serialization is the process of turning an object in memory into a stream of byte so you can do stuff like store it on disk or send it over the network. A C# object can be serialized to XML as specified- ⦁ To use Serialization in xml we need XmlSerializer class. ⦁ This class is derived from System.Xml.Serialization. ⦁ Only public objects can be serialized in XML serialization # How to do XML Serialization? *There are many ways in …