Archives for All Articles - Page 6
Understanding JSONP and its Security Issues
Problem Statement If you are developing a web application and trying to load a data from other domain then a browser will not allow this request and raises an error…
Understanding EF Code First Migrations
Introduction Entity Framework is one of the topmost rich ORM tool from Microsoft targeting .NET framework. Entity Framework can be used with different approaches like Code-First, Database First, and Model…
EF Code-First Approach Vs Database First Approach
Following are some of the advantages and disadvantages on each Approaches of Entity Framework Code-First Approach Advantages No need to look at database for any changes in the tables as we can…
Using Entity Framework Working with Multiple Similar Databases at Run time
Problem Statement: There will be a situation where we need to connect and run some queries parallelly to our n number of clients with same database structure. Following is the approach to…
Centralizing Configuration in .NET Application
Problem Statement Recently I got a requirement where I have many modules and each is independent applications like some are the web application, WinForms and also we have windows services. But here…
What is AAR (Application Request Routing) Affinity?
Application Request Routing (ARR) is a feature where when a client (or browser) request to any Azure based website, a cookie will be created and stick to the first time…
Why is .NET Core recommended for new Modern web Applications?
These days, as a modern web application, customers having high expectations of rich and intuitive UI design, secure and flexibility as the minimum requirement. These requirements can be achieved by the traditional .NET framework. But, why Core…
Getting Computer Name from IP Address and Vice Versa in C#
Problem Statement Need to get the IP address of the given machine name as well as need to get the Machine Name from given IP Address. Solution Using DNS class in you can…
Working with Default Parameters in SQL Server Functions
As in any programming language, we can even set the default parameters for the Functions and Procedures on SQL Server. But calling these functions or procedures will differ with how we…
Calling REST API Service From SQL Server Using C# SQL CLR
Problem Statement A requirement where we need to get a data from other sources (REST-based Web Service) and sync with on-premises (local) database. This should be done using a SQL…