c#和mysql之间的类型_支持多类型数据库的c#数据库模型示例

using System;

using System.Collections.Generic;

using System.Text;

namespace DynamicFramework

{

public sealed class DbHelper

{

public static List ToList(System.Data.IDataReader reader)

{

List list = new List();

Csla.Data.SafeDataReader sr = new Csla.Data.SafeDataReader(reader);

while (sr.Read())

{

T t = Activator.CreateInstance();

Type entityType = t.GetType();

for (int i = 0; i < sr.FieldCount; i++)

{

string pName = reader.GetName(i);

System.Reflection.PropertyInfo p = entityType.GetProperty(pName);

if (p != null)

{

p.SetValue(t, GetValue(p,sr,i), null);

}

}

list.Add(t);

}

return list;

}

private static object GetValue(System.Reflection.PropertyInfo p,Csla.Data.SafeDataReader sr,int index)

{

if (p.PropertyType == typeof(string))

{

return sr.GetString(index);

}

else if (p.PropertyType == typeof(int))

{

return sr.GetInt32(index);

}

else if (p.PropertyType == typeof(decimal))

{

return sr.GetDecimal(index);

}

else if (p.PropertyType == typeof(DateTime))

{

return sr.GetDateTime(index);</