How To
How to check net framework version
1/20/2025 3:47:15 AM 149
To check the .NET Framework version installed on a Windows machine, you can use several methods depending on your preference.
Left Join in C# LINQ
1/20/2025 3:15:15 AM 56
A Left Join in C# LINQ is used to combine two data sources based on a common key, ensuring that every element in the first (left) data source is included in the result set, even if there is no corresponding element in the second (right) data source.
Inner Join in C# LINQ
1/20/2025 3:14:00 AM 73
An inner join in C# LINQ allows you to create a result set by combining elements from two collections where a matching key exists.
Group By in C# LINQ
1/20/2025 3:13:02 AM 58
In C#, LINQ's Group By is a query operator that allows you to organize elements of a sequence into groups based on a specified key selector function.
How to use custom attributes in C#
1/18/2025 3:00:29 AM 146
Attributes are used to attach additional metadata to classes, methods, properties, or other program elements.
How to Set Connection Timeout for TcpClient in C#
1/18/2025 2:58:44 AM 283
In C#, the TcpClient class doesn't directly provide a way to set a connection timeout.
Monitor data changes with SQL Server query notifications
1/18/2025 2:56:09 AM 203
You can use SQL Server query notifications to trigger push notifications in your application whenever there's a change in the database.
Retrieve a Single Row with Dapper in C#
1/18/2025 2:53:30 AM 183
When you need to retrieve a single row from a database using Dapper, the simplest approach is to use the QuerySingleOrDefault() method.
Update records with Dapper in C#
1/18/2025 2:50:58 AM 228
You can update records in a database using Dapper by leveraging the Execute() method along with an UPDATE statement.
Advanced Dapper Features in C#
1/18/2025 2:33:59 AM 195
Dapper is a high-performance Object-Relational Mapping (ORM) tool designed for .NET developers, offering fast, lightweight, and efficient data access.
Format Numbers to 2 Decimals in C# with Dapper
1/18/2025 2:33:47 AM 141
If you encounter an issue when inserting numeric data into a SQL database using Dapper.
How to Trim String Values in C# with Dapper
1/18/2025 2:33:42 AM 133
When working with Dapper to call a stored procedure, I encountered an issue where the strings returned from the stored procedure were not trimmed.
