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]); } }
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)); }