public void TestSqlServerAnsiString()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.SqlServer);
var dataType = mapper.Map(DbType.AnsiString);
//assert
Assert.AreEqual("VARCHAR", dataType);
}
public void TestPostgreSql()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.PostgreSql);
var dataType = mapper.Map(DbType.Int32);
//assert
Assert.AreEqual("INTEGER", dataType);
}
public void TestOracle()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.Oracle);
var dataType = mapper.Map(DbType.Int32);
//assert
Assert.AreEqual("NUMBER(9)", dataType);
}
public void TestPostgreSqlDecimal()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.PostgreSql);
var dataType = mapper.Map(DbType.Decimal);
//assert
Assert.AreEqual("DECIMAL", dataType);
}
public void TestSqlServerCe()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.SqlServerCe);
var dataType = mapper.Map(DbType.Int32);
//assert
Assert.AreEqual("INT", dataType);
}
public void TestSqLiteUnicodeString()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.SQLite);
var dataType = mapper.Map(DbType.String);
//assert
Assert.AreEqual("TEXT", dataType);
}
public void TestSqLiteDecimal()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.SQLite);
var dataType = mapper.Map(DbType.Decimal);
//assert
Assert.AreEqual("NUMERIC", dataType);
}
public void TestOracleUnicodeString()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.Oracle);
var dataType = mapper.Map(DbType.String);
//assert
Assert.AreEqual("NVARCHAR2", dataType);
}
public void TestMySqlUnicodeString()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.MySql);
var dataType = mapper.Map(DbType.String);
//assert
Assert.AreEqual("VARCHAR", dataType);
}
public void TestUnicodeStringViaTable()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(new DatabaseTable());
var dataType = mapper.Map(DbType.String);
//assert
Assert.AreEqual("NVARCHAR", dataType);
}
public void TestPostgreSql()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.PostgreSql);
var dataType = mapper.Map(DbType.DateTime2);
//assert
Assert.AreEqual("TIMESTAMP", dataType);
}
public void TestSqLite()
{
var mapper = DataTypeMappingFactory.DataTypeMapper(SqlType.SQLite);
var dataType = mapper.Map(DbType.DateTime2);
//assert
Assert.AreEqual("DATETIME", dataType);
}
public void TestUnicodeStringViaTableWithSchema()
{
var schema = new DatabaseSchema(null, "System.Data.OracleClient");
var table = schema.AddTable("Orders");
var mapper = DataTypeMappingFactory.DataTypeMapper(table);
var dataType = mapper.Map(DbType.String);
//assert
Assert.AreEqual("NVARCHAR2", dataType);
}
/// <summary>
/// Adds the column.
/// </summary>
/// <param name="databaseColumn">The database column.</param>
/// <param name="columnName">Name of the column.</param>
/// <param name="dbType"><see cref="DbType"/>.</param>
/// <param name="columnInitialization">The column initialization.</param>
/// <returns></returns>
public static DatabaseColumn AddColumn(this DatabaseColumn databaseColumn, string columnName, DbType dbType, Action <DatabaseColumn> columnInitialization)
{
if (databaseColumn == null)
{
throw new ArgumentNullException("databaseColumn", "databaseColumn must not be null");
}
var dataType = DataTypeMappingFactory.DataTypeMapper(databaseColumn.Table).Map(dbType);
return(databaseColumn.AddColumn(columnName, dataType, columnInitialization));
}
private static string TypeToString(DatabaseTable databasetable, Type type)
{
if (type == typeof(string))
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(DbType.String));
}
if (type == typeof(byte[]))
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(DbType.Binary));
}
if (type.IsValueType)
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(type));
}
return("VARCHAR");
}
private static string TypeToString(DatabaseTable databasetable, Type type)
{
if (type == typeof(string))
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(DbType.String));
}
if (type == typeof(byte[]))
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(DbType.Binary));
}
#if NETSTANDARD1_5
var typeInfo = type.GetTypeInfo();
var isValue = typeInfo.IsValueType;
#else
var isValue = type.IsValueType;
#endif
if (isValue)
{
return(DataTypeMappingFactory.DataTypeMapper(databasetable).Map(type));
}
return("VARCHAR");
}
/// <summary>
/// Adds a column.
/// </summary>
/// <param name="databaseTable">The database table.</param>
/// <param name="columnName">Name of the column.</param>
/// <param name="dbType"><see cref="DbType"/>.</param>
/// <param name="columnInitialization">The column initialization.</param>
/// <returns></returns>
public static DatabaseColumn AddColumn(this DatabaseTable databaseTable, string columnName, DbType dbType, Action <DatabaseColumn> columnInitialization)
{
var dataType = DataTypeMappingFactory.DataTypeMapper(databaseTable).Map(dbType);
return(databaseTable.AddColumn(columnName, dataType, columnInitialization));
}
