Loading
Jignesh Trivedi's contributions
Tips to Improve SQL Database Performance
Learn practical SQL Server query-performance tips, including efficient SELECT statements, joins, indexed views, stored procedures, transactions, and parameterized queries.
Routing in ASP.Net MVC
A route is a URL pattern. Routing is a pattern matching process that monitors the requests and determines what to do with each request.
ASPX View Engine VS Razor View Engine
View engines render HTML to the browser. ASP.Net MVC supports ASPX and Razor View Engines by default, with options for third-party engines. ASPX syntax mirrors ASP.Net web forms, while Razor offers a more modern approach, enhancing code readability and testability.
ASP.Net MVC Request Life Cycle
This article introduces the ASP.Net MVC Request Life Cycle. There are primarily seven stages in the ASP.Net Request life cycle.
MVC VS ASP.Net Web Form
This article introduces the Model-View-Controller (MVC) architectural pattern for use in ASP.Net Web forms.
Association, Aggregation and Composition
Association, aggregation and composition terms represent the relationship between the objects. They are very basic stuff of Object oriented programming.
Auto Incremented Column With VARCHAR and NVARCHAR Data Type in SQL
This article answers questions about Auto-incremented ID with the VARCHAR / NVARCAHAR data type in SQL Server.
State Design Pattern
The State Pattern (also referred to as State Design Pattern) is one of the behavioral patterns. It defines a manner for controlling communication among classes or entities.
Inheritance VS Composition
The relationship among classes is one of the fundamental activities of software design. There are two ways to relate classes: inheritance and composition.
ViewData VS ViewBag Vs TempData in MVC
We have three options: ViewData, ViewBag, and TeampData for passing data from controller to view and in the next request.
Deep Copy of Object in C#
In this article, we can create deep copy of an object with the help of Serialization and Reflection.
Extended Properties in SQL Server
Extended Properties in SQL Server allows us to create additional customized properties to store additional information. Extended Properties are a way to create a self-documenting database.
ObjectContext VS DBContext
ObjectContext and DbContext has capability to querying and working with data as objects.
How To Call Stored Procedure In Entity Framework
Learn how to call SQL Server stored procedures in Entity Framework by importing them as functions or using ExecuteStoreQuery with custom result types.
Extended Event in SQL Server
SQL server Extended event is nothing but event handling system for server system.
How To Prevent Dead Lock in Entity Framework
Recently I am working on Entity Framework as a data access layer-based Project. We found many performance issues with this application.
WCF Performance Tuning
WCF (Windows Communication Foundation) enables network distributed services with a service-oriented approach. Improving its performance involves selecting proper bindings, understanding throttling, optimizing serialization, implementing caching, adhering to SQL Server best practices.
Comma Separated Value in SQL Query
I have reviewed and answered many articles related to SQL Server. For the previous one and a half months, I found 3 to 4 articles related to finding comma separated values in SQL Server. So I decided to write an article on Comma Separated Values in SQL, it might help people who are looking for a solution of this.
SingleOrDefault() Vs. FirstOrDefault() in LINQ Query
SingleOrDefault() returns a single element from a sequence or a default value if no element exists. FirstOrDefault() retrieves the first element or a default if the sequence is empty. Both are LINQ methods for data querying, offering flexibility in handling single results from collections.
Precompiled and Pre-generated Views in the Entity Framework
While working with the Entity Framework, we can reduce the delay of the initial view by creating the view at compile time instead of runtime
Tips to Improve Entity Framework Performance
There are some points that we should consider while designing and querying databases using the Entity Framework ORM.
SPARSE Column in SQL Server
SPARSE column is ordinary type column that has an optimized storage for NULL values.
GROUPING SETS Clause in SQL Server
In this article we explain the GROUPING SETS clause in SQL Server.
