SHASHANGKA SHEKHAR'S BLOG

Hi, I am Shashangka Shekhar, Working with Microsoft Technologies. This is my personal blog where I share some of my experiences.

Create a Web Browser in C# VS-2015

Today we will focus on creating our own web browser.

C# Web Browser actually provides an Internet Explorer control. The control has several properties, methods, and events that we can use to implement user interface features.


Read More

SQL Server 2012 VS SQL Server 2014

There are many performance enhancements in SQL Server 2014.

  1. Standard and BI Editions now support 128 GB of memory (SQL Server 2008 R2 and 2012 only supports 64 GB).
  2. In-Memory Online Transaction Processing(OLTP)  a new in-memory engine is a new lock-free, latch-free, optimistic concurrency approach to storing your data in memory. This is nothing like DBCC PINTABLE we might remember from years ago, which still suffered from the locking and latching problems that are resolved in SQL Server 2014.
  3. SQL Server 2014 now supports native backup encryption in Standard, BI and Enterprise Editions.
  4. Support for window functions, which makes it possible to write fast queries for running totals, sliding windows etc.
  5. Columnstore indexes, which can speed up data warehouse enormously. But of no interest for OLTP. Only writable in SQL 2014.

Difference between Stored Procedure and Function

  • Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values).
  • Functions can have only input parameters for it whereas Procedures can have input/output parameters .
  • Functions can be called from Procedure whereas Procedures cannot be called from Function.

CRUD – ASP.Net MVC, Web Api-2, Windows Form

In this article we will learn basic CRUD operation using Web Api-2, and Stored Procedure with a sample Desktop Application.

Download Source Code

0

Sample Database:

Let’s Create a Sample database named ‘SampleDB’ with SQL Management Studio. Using the ‘SampleDB’ now create a Table name ‘tblCustomer’.

Script:

Read More

Error & Exception

In this article we will focus on Exception Handling, clarify our knowledge on different type of Exceptions, and also identify difference between Exception and Error.

Short Overview:

Error:

  1. Error means system doesn’t handle.
  2. Stop the application being executed with errors.
  3. Cause while syntax error, may occur while writing code.

Exception:

  1. Abnormal things happen cause Exception.
  2. Interrupts the application execution.
  3. Cause while application logic fails, something exceptional.

Read More

ASP.NET MVC – Using JQuery, AJAX

In this article we will clarify our knowledge about using and posting a form with JQuery and Ajax.

Before dive into core topic let’s have an overview about JQuery and Ajax. What is it?

What is JQuery?

Well, JQuery is a framework (tools) for writing JavaScript, Walk as “write less, do more”, jQuery is to make easier to use JavaScript.

What is JavaScript?

JavaScript is an object-oriented computer programming (Scripting)language commonly used to create interactive effects within web browsers.

Read More

CRUD Operation Using ASP.Net MVC-5

In This post we will learn Basic CRUD operation using ASP.Net MVC, JSON, ADO.Net, and Stored Procedure with a sample MVC Application.

Our first step is to create and design a SQL Database, below step’s we have the demonstration of creating a database table and very basic CRUD Stored Procedure. Read More

QA-MVC ASP.Net

In this article,  explaining best MVC ASP.Net Interview Questions and Answers as following:

Q.What is ActionResult() ?

Ans: It is an abstract Class Read More

Aggregate Functions in SQL Server

Let’s create a SampleDB database fist with SQL Management Studio. Now create a table in SampleDB.

Insert Sample Data:

Aggregate Functions in SQL Server

COUNT (Transact-SQL)

Returns the number of items in a group. COUNT always returns an int data type value. Read More

IEnumerable Vs IQueryable

Differences between them based on their properties :

IEnumerable

  1. NamespaceSystem.Collections Namespace
  2. Derives from: No base interface
  3. Deferred Execution : Supported
  4. Lazy Loading : Not Supported
  5. How does it work : While querying data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data. Hence does more work and becomes slow.
  6. Suitable for : LINQ to Object and LINQ to XML queries.
  7. Custom Query : Doesn’t supports.
  8. Extension method parameter : Extension methods supported in IEnumerable takes functional objects.
  9. When to use : When querying data from in-memory collections like List, Array etc.
  10. Best Uses : In-memory traversal

Read More

List few advantages of Stored Procedure.

  • Stored procedure can reduced network traffic and latency, boosting application performance.
  • Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead.
  • Stored procedures help promote code reuse.
  • Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
  • Stored procedures provide better security to your data.