CsvDataReader GetTypedReader()
{
var tr = File.OpenText("Data\\Types.csv");
var schema = new TypedCsvSchema();
schema.Add("Byte", typeof(byte));
schema.Add("Int16", typeof(short));
schema.Add("Int32", typeof(int));
schema.Add("Int64", typeof(long));
schema.Add("Char", typeof(char));
schema.Add("String", typeof(string));
schema.Add("Bool", typeof(bool));
schema.Add("Float", typeof(float));
schema.Add("Double", typeof(double));
schema.Add("DateTime", typeof(DateTime));
schema.Add("Decimal", typeof(decimal));
schema.Add("Guid", typeof(Guid));
var opts = new CsvDataReaderOptions()
{
Schema = schema
};
return(CsvDataReader.Create(tr, opts));
}
public void CustomSchema()
{
using var sr = TestData.GetTextReader();
var schema = new TypedCsvSchema();
schema.Add("UID", typeof(int));
var csv = CsvDataReader.Create(sr, new CsvDataReaderOptions {
Schema = schema
});
}
public void SylvanDataTable()
{
var schema = new TypedCsvSchema();
schema.Add(0, typeof(int));
schema.Add(1, typeof(string));
schema.Add(2, typeof(double?));
schema.Add(3, typeof(DateTime));
schema.Add(4, typeof(DateTime?));
var options = new CsvDataReaderOptions
{
Schema = schema
};
using var tr = GetData();
using var dr = CsvDataReader.Create(tr, options);
var dt = new DataTable();
dt.Load(dr);
}
public async Task BinaryValues()
{
using (var reader = File.OpenText("Data\\Binary.csv"))
{
var schema = new TypedCsvSchema();
schema.Add(1, typeof(byte[]));
var opts = new CsvDataReaderOptions()
{
Schema = schema
};
var csv = await CsvDataReader.CreateAsync(reader, opts);
csv.Read();
var vals = new object[2];
csv.GetValues(vals);
var expected = Encoding.ASCII.GetBytes(BinaryValue1);
Assert.Equal(expected, (byte[])vals[1]);
csv.Read();
csv.GetValues(vals);
expected = Encoding.ASCII.GetBytes(BinaryValue2);
Assert.Equal(expected, (byte[])vals[1]);
}
}
