static void Main(string[] args)
{
const string connectionString = "Data Source=dev-app3.abax.local;Initial Catalog=ETS;User Id=T2F_Web;password=ets;MultipleActiveResultSets=True";
var schema = DbSchemaReader.ReadTableSchema(() => new SqlConnection(connectionString), "dbo.GpsTrip");
// var properties = schema.Select(PropertyDefinitionFactory.FromDbColumnInfo).ToArray();
// Console.WriteLine(properties.Length);
}
public async Task Initialize()
{
Log.Debug("Initializing single table queue gateway");
var schema = await DbSchemaReader.ReadTableSchema(_connectionFactory, _tableName).ConfigureAwait(false);
_properties = schema.Where(x => x.Name.ToLower() != "rownumber").Select(FromDbColumnInfo).ToArray();
_messageType = MessageTypeProvider.BuildMessageType(new MessageTypeDefinition(_type, _properties));
Log.Debug("Initialization complete");
}
public async Task Initialize()
{
Log.Debug("Initializing JSON table queue gateway");
var schema = (await DbSchemaReader.ReadTableSchema(_connectionFactory, _tableName).ConfigureAwait(false)).ToArray();
ExpectColumnType(schema, _columnNames.Timestamp, typeof(DateTime));
ExpectColumnType(schema, _columnNames.MessageType, typeof(string));
ExpectColumnType(schema, _columnNames.Payload, typeof(string));
Log.Debug("Initialization complete");
}