public void TestGetDecimalValueGetFieldValue()
{
KoraliumConnectionStringBuilder builder = new KoraliumConnectionStringBuilder();
builder.DataSource = webFactory.GetUrl();
KoraliumConnection connection = new KoraliumConnection();
connection.ConnectionString = builder.ConnectionString;
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandText = "select decimalvalue from typetest";
var reader = cmd.ExecuteReader();
var decimalordinal = reader.GetOrdinal("decimalvalue");
List <decimal> actual = new List <decimal>();
while (reader.Read())
{
var val = reader.GetFieldValue <decimal>(decimalordinal);
actual.Add(val);
}
List <decimal> expected = new List <decimal>
{
1,
3,
17,
1,
3
};
Assert.AreEqual(expected, actual);
}
public void TestSelectString()
{
KoraliumConnectionStringBuilder builder = new KoraliumConnectionStringBuilder();
builder.DataSource = webFactory.GetUrl();
KoraliumConnection connection = new KoraliumConnection();
connection.ConnectionString = builder.ConnectionString;
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandText = "select * from project";
var reader = cmd.ExecuteReader();
var companyOrdinal = reader.GetOrdinal("company");
while (reader.Read())
{
var company = reader.GetFieldValue <Company>(companyOrdinal);
}
}