Farhan Ahmed's contributions

Learn how these helpers enhance type safety and streamline the generation of HTML elements in Razor views, leveraging view models and data annotations for robust, dynamic web forms and UI components.

In this blog. I will explain you how to find random record in SQL server. This is most common interview question. The CHECKSUM function returns the checksum value computed over a table row, or over an expression list. Use CHECKSUM to build hash indexes. A hash index will result if the CHECKSUM function has column arguments, and an index is built over the computed CHECKSUM value. This can be used for equality searches over the columns. SQL NEWID function is used for selecting random row from a result set in SQL Server databases. NEWID is use to assign a value to a variable declared as the uniqueidentifier data type.

Learn to build RESTful services by defining endpoints and handling HTTP requests. Perfect for developers aiming to master CRUD operations and backend development with .NET.

In this article, I will demonstrate new input types in HTML 5. HTML 5 introduces several input types like Date, DateTime-local, time, week, month, email, tel, URL, search, range, color and number. To improve the user experience and to make the forms more interactive. However, if a browser failed to recognize these new input types, it will treat them like a normal text box.

This article covers the Bootstrap 4 Popover component, a versatile tool for displaying pop-up content when users interact with elements. It highlights key features such as initialization with jQuery, integration with Popper.js for positioning, and various triggering methods (click, focus, hover).

This article will demonstrate you, how you can use bootstrap 4 cards components. A card is a flexible and extensible content container. It includes options for headers and footers, a wide variety of content, contextual background colors, and powerful display options.

In this article. I will demonstrate how we can perform join operation with SQL database using Language-Integrated Query (LINQ).

In this article. I will demonstrate how we can use Where and OfType operator of Language-Integrated Query (LINQ).

In this article. I will demonstrate how we can use Sum, Min, Max Count, Average, LongCount, Aggregate operator of Language-Integrated Query (LINQ). Sum, Min, Max Count, Average, LongCount, Aggregate operators are part of aggregation operation in Language-Integrated Query (LINQ).

In this article, I will demonstrate how we can use GroupBy and ToLookup operator of Language-Integrated Query (LINQ). GroupBy and ToLookup operators are part of grouping data in Language-Integrated Query (LINQ). Grouping refers to the operation of putting data into groups so that the elements in each group share a common attribute. GroupBy & ToLookup return a collection that has a key and an inner collection based on a key field value. The execution of GroupBy is deferred whereas that of ToLookup is immediate. A LINQ query syntax can be end with the GroupBy or Select clause.

In this article, I will demonstrate how we can use OrderBy, OrderByDescending, ThenBy, ThenByDescending and Reverse operator of Language-Integrated Query (LINQ). OrderBy, OrderByDescending, ThenBy, ThenByDescending and Reverse operators are part of sorting data in Language-Integrated Query (LINQ).

In this article. I will demonstrate how we can customize asp.net web API Media formatter and retrieve data in format as we want like XML or JSON. I will retrieve data from SQL database and format them in json format. XML is default format in asp.net web API.

In this article. I will demonstrate how to import XML data into SQL server using MVC 5 and entity framework. I will create a XML file and upload it into FileUpload in project. I will also use jQuery datatable plugging for searching, shorting and paging.

In this article. I will demonstrate how to How to dynamically load employee details using MVC 5 and Entity Framework.

In this article, I will demonstrate how to import JSON data into SQL server using MVC 5 and Entity Framework. I will create a JSON file and upload it into FileUpload in the project.