Always remain updated about current software development trends

Articles having tag: SQL

.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language

.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.

.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language-Utility

Utility for .NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.

Dynamic Querying with LINQ-to-Entities and Expressions

This article explains how to create a general-purpose data-access library for creating dynamic queries using LINQ-to-Entities.

Continuous Database Integration

Using NAnt and CruiseControl.NET to continuously integrate database changes

Be careful with varchars in Dapper!

In this post I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.

Relative Constraints and Permissioning in T-SQL

Implementation of relative database constraints and permissioning using triggers and shadow tables.

Failover or Restart Results in Reseed of Identity – FIX

Simply run the script and then every time SQL is restarted all your Identity columns will be reset to the latest available seed.