public void ParseSqlDataType() { var typeProvider = new AccessDataTypeProvider(); var dataType = typeProvider.Parse("Binary"); Assert.AreEqual(OleDbType.Binary, dataType.SqlDbType); dataType = typeProvider.Parse("Bit"); Assert.AreEqual(OleDbType.Boolean, dataType.SqlDbType); dataType = typeProvider.Parse("BIT"); Assert.AreEqual(OleDbType.Boolean, dataType.SqlDbType); dataType = typeProvider.Parse("DateTime"); Assert.AreEqual(OleDbType.Date, dataType.SqlDbType); dataType = typeProvider.Parse("Date"); Assert.AreEqual(OleDbType.Date, dataType.SqlDbType); Console.WriteLine(dataType.ToQueryString()); dataType = typeProvider.Parse("VarChar(30)"); Assert.AreEqual(dataType.Size, 30); dataType = typeProvider.Parse("(30)"); Assert.AreEqual(dataType.Size, 30); }
public void ToQueryString() { var dataTypeProvider = new AccessDataTypeProvider(); var dataType = dataTypeProvider.From(typeof(string)); Assert.IsTrue(dataType.Size > 0); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(byte[])); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(decimal)); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(Int32)); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(long)); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(Single)); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(Double)); Console.WriteLine(dataType.ToQueryString()); dataType = dataTypeProvider.From(typeof(Byte[])); Console.WriteLine(dataType.ToQueryString()); }
public void GetSqlDataType() { var typeProvider = new AccessDataTypeProvider(); var dataType = typeProvider.From(typeof(byte[])); Assert.AreEqual(OleDbType.Binary, dataType.SqlDbType); dataType = typeProvider.From(typeof(string)); Assert.AreEqual(OleDbType.VarChar, dataType.SqlDbType); dataType.Size = 50; Assert.AreEqual("VARCHAR(50)", dataType.ToQueryString().ToUpper()); dataType = typeProvider.From(typeof(ALinq.Binary)); }