/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <param name="type"></param>
/// <returns></returns>
public static object ToAny(object value, Type type)
{
switch (type.Name)
{
case "Boolean":
return(DbDataConvert.ToBoolean(value));
case "Byte":
return(DbDataConvert.ToByte(value));
case "Byte[]":
return(DbDataConvert.ToByteArray(value));
case "Char":
return(DbDataConvert.ToChar(value));
case "DateTime":
return(DbDataConvert.ToDateTime(value));
case "Decimal":
return(DbDataConvert.ToDecimal(value));
case "Double":
return(DbDataConvert.ToDouble(value));
case "Single":
return(DbDataConvert.ToFloat(value));
case "Int32":
return(DbDataConvert.ToInt(value));
case "Int64":
return(DbDataConvert.ToLong(value));
case "Int16":
return(DbDataConvert.ToShort(value));
case "String":
return(DbDataConvert.ToString(value));
case "UInt32":
return(DbDataConvert.ToUInt(value));
case "UInt64":
return(DbDataConvert.ToULong(value));
case "UInt16":
return(DbDataConvert.ToUShort(value));
case "Guid":
return(DbDataConvert.ToGuid(value));
}
return(value);
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public virtual bool IsTableEmpty(string tableName)
{
string __sql = string.Format("select count(*) from {0}", tableName);
using (IDbConnection __connection = this.CreateConnection()) {
__connection.ConnectionString = DataAccess.ConnectionStringSettings[this.ConnectionName].ConnectionString;
__connection.Open();
try {
using (IDbCommand __command = this.CreateCommand(__sql, CommandType.Text, __connection)) {
__command.CommandType = CommandType.Text;
return(DbDataConvert.ToInt(__command.ExecuteScalar()) == 0);
}
}
finally {
try {
__connection.Close();
}
catch { }
}
}
}
