Data Validation in Entity Framework

Validating data is important to make sure bad data is not getting into the system causing unnecessary troubles. When developing applications using Entity Framework, you can use features in .NET and Entity Framework to ensure only valid data will flow through it. Here we'll see what features we can use with Entity Framework to do our job Using Data-Annotations Data-Annotations are attributes...

Read More

Interesting Findings in SQL Server

Interesting findings articles gives small tips and findings  you can use for the particular technology Difference between datetime and datetime2 (SO) DATETIME2 has a date range of "0001 / 01 / 01" through "9999 / 12 / 31" while the DATETIME type only supports year 1753-9999 DATETIME2 is more accurate when compared to DATETIME What is LocalDB This was introduced in SQL Server 2012....

Read More

Evolving of ASP.NET Identity System

ASP.NET Membership Provider First introduced in 2005 Uses SQL Server database or Active Directory  See how to use ASP.NET membership provider SqlMembershipProvider Manages Membership information in a SQL Server database ActiveDirectoryMembershipProvider Manages and store membership information in Active Directory. LDAP  (Lightweight Directory Access Protocol) : Is a protocol used...

Read More