public void ValidateStringLength()
{
using (var context = new StringTypesContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Database.OpenConnection();
MySqlConnection conn = (MySqlConnection)context.Database.GetDbConnection();
MySqlCommand cmd = new MySqlCommand(
$"DESC StringType",
conn);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
Assert.True(reader.Read());
Assert.Equal("TinyString", reader.GetString("field"));
Assert.Equal("varchar(767)", reader.GetString("type"));
Assert.True(reader.Read());
Assert.Equal("LongString", reader.GetString("field"));
Assert.Equal("text", reader.GetString("type"));
Assert.True(reader.Read());
Assert.Equal("MediumString", reader.GetString("field"));
Assert.Equal("mediumtext", reader.GetString("type"));
Assert.True(reader.Read());
Assert.Equal("NormalString", reader.GetString("field"));
Assert.Equal("varchar(3000)", reader.GetString("type"));
}
}
}
public void ValidateStringLength()
{
using (var context = new StringTypesContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
Dictionary <string, string> validation = new Dictionary <string, string>
{
{ "TinyString", "varchar(767)" },
{ "NormalString", "varchar(3000)" },
{ "MediumString", "mediumtext" },
{ "LongString", "text" }
};
context.Database.OpenConnection();
MySqlConnection conn = (MySqlConnection)context.Database.GetDbConnection();
MySqlCommand cmd = new MySqlCommand(
$"DESC StringType",
conn);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int counter = 0;
while (reader.Read())
{
string field = reader.GetString("field");
string type = validation[field];
Assert.Equal(type, reader.GetString("type"));
counter++;
}
Assert.Equal(validation.Count, counter);
}
}
}
public void OneTimeTearDown()
{
using (var context = new AllDataTypesContext())
context.Database.EnsureDeleted();
using (var context = new StringTypesContext())
context.Database.EnsureDeleted();
}
