R – Generic DataAccess Layer in C# 3.5

data-access-layergenerics

What are the best practices to creating a Generic DataAccess Layer in C# 3.5. Dose LINQ to SQL have any support for Other DataSources like MySQL , Oracle etc.

Best Answer

LINQ to SQL is SQL Server only, and is likely to remain that way. If you want support for other databases then use LINQ To Entities. You can read a comparison between LINQ to SQL and LINQ to Entities here.

Related Solutions

C# – Null or default comparison of generic argument in C#

To avoid boxing, the best way to compare generics for equality is with EqualityComparer<T>.Default. This respects IEquatable<T> (without boxing) as well as object.Equals, and handles all the Nullable<T> "lifted" nuances. Hence:

if(EqualityComparer<T>.Default.Equals(obj, default(T))) {
    return obj;
}

This will match:

null for classes
null (empty) for Nullable<T>
zero/false/etc for other structs

C# – Create Generic method constraining T to an Enum

Since Enum Type implements IConvertible interface, a better implementation should be something like this:

public T GetEnumFromString<T>(string value) where T : struct, IConvertible
{
   if (!typeof(T).IsEnum) 
   {
      throw new ArgumentException("T must be an enumerated type");
   }

   //...
}

This will still permit passing of value types implementing IConvertible. The chances are rare though.

Best Answer

Related Solutions

C# – Null or default comparison of generic argument in C#

C# – Create Generic method constraining T to an Enum

Related Topic