Pages

▼

Inflate DataTable To Data Entity (Generic class)

Inflate DataTable To Data Entity (Generic class)
DataToEntity  is usefull for Dot Net 2.0 where developer can convert ADO.NET's  DataTable convert into object without extra coding.
 
using System;
using System.Collections.Generic;
using System.Data;
using System.Reflection;
 

namespace Dotnet2Test
{
    public static class DataToEntity
    {
        #region inflate
        ///
        /// Inflate data from dataset tot entity
        ///
        public static TEntityCollection Inflate<TEntityCollection, TEntity>(DataSet ds)
            where TEntityCollection : List<TEntity>, new()
            where TEntity : new()
        {
            TEntityCollection entityCollection = new TEntityCollection();

            DataTable dt = null;
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables.Count == 1)
                    dt = ds.Tables[0];
                else
                    dt = ds.Tables[typeof (TEntity).Name];
            }
            else
                throw new Exception("invalid Dataset");
            return Inflate<TEntityCollection>(dt);

        }

        public static TEntityCollection Inflate<TEntityCollection, TEntity>(DataTable dt)
            where TEntityCollection : List<TEntity>, new()
            where TEntity : new()
        {
            TEntityCollection entityCollection = new TEntityCollection();
            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    TEntity tmpEntity = Inflate<TEntity>(dr);
                    entityCollection.Add(tmpEntity);
                }
            }
            else
                throw new Exception("No data found");
            return entityCollection;
        }


        ///
        /// Inflate data from dataset tot entity
        ///
        ///
        public static TEntity Inflate<TEntity>(DataSet ds)
            where TEntity : new()
        {
            DataTable dt = null;
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables.Count == 1)
                    dt = ds.Tables[0];
                else
                    dt = ds.Tables[typeof (TEntity).Name];
            }
            else
                throw new Exception("invalid Dataset");
            return Inflate<TEntity>(dt);
        }
 
        public static TEntity Inflate<TEntity>(DataTable dt)
            where TEntity : new()
        {
            TEntity tmpEntity = new TEntity();
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                    tmpEntity = Inflate<TEntity>(dt.Rows[0]);
                else
                    throw new Exception("No data found");
            }
            else
                throw new Exception("No data found");
            return tmpEntity;
        }
 
        public static TEntity Inflate<TEntity>(DataRow dr)
            where TEntity : new()
        {
            TEntity tmpEntity = new TEntity();
            Inflate(dr, tmpEntity);
            return tmpEntity;
        }

        public static void Inflate(DataRow dr, object tmpEntity)
        {
            if (dr != null && tmpEntity != null)
            {
                foreach (DataColumn dc in dr.Table.Columns)
                {
                    PropertyInfo metadata = tmpEntity.GetType().GetProperty(dc.ColumnName);
                    if (metadata != null)
                    {
                        metadata.SetValue(tmpEntity, dr[dc], null);
                    }
                }
            }
            else
                throw new Exception("No data found or entity is null");
        }
        #endregion
    }
}