/// <summary> /// Reads the table data and invokes the function for each INSERT statement. The databaseTable must have dataTypes (call DataReader.DataTypes()). /// </summary> /// <param name="databaseTable">The database table.</param> /// <param name="connectionString">The connection string.</param> /// <param name="providerName">Name of the provider.</param> /// <param name="processRecord">The process record.</param> public void ReadTable(DatabaseTable databaseTable, string connectionString, string providerName, Func <string, bool> processRecord) { var r = new Reader(databaseTable, connectionString, providerName); var w = new InsertWriter(databaseTable, FindSqlType(providerName)); r.Read(record => { var s = w.WriteInsert(record); return(processRecord(s)); }); }
/// <summary> /// Reads the table data and invokes the function for each INSERT statement. The databaseTable must have dataTypes (call DataReader.DataTypes()). /// </summary> /// <param name="databaseTable">The database table.</param> /// <param name="connection">The connection.</param> /// <param name="processRecord">The process record.</param> public void ReadTable(DatabaseTable databaseTable, DbConnection connection, Func <string, bool> processRecord) { var providerName = connection.GetType().Namespace; #if NETSTANDARD2_0 var r = new Reader(databaseTable); #else var r = new Reader(databaseTable, connection.ConnectionString, providerName); #endif var w = new InsertWriter(databaseTable, FindSqlType(providerName)); r.Read(connection, record => { var s = w.WriteInsert(record); return(processRecord(s)); }); }
/// <summary> /// Reads the table data and invokes the function for each INSERT statement. The databaseTable must have dataTypes (call DataReader.DataTypes()). /// </summary> /// <param name="databaseTable">The database table.</param> /// <param name="connectionString">The connection string.</param> /// <param name="providerName">Name of the provider.</param> /// <param name="processRecord">The process record.</param> public void ReadTable(DatabaseTable databaseTable, string connectionString, string providerName, Func<string, bool> processRecord) { var r = new Reader(databaseTable, connectionString, providerName); var w = new InsertWriter(databaseTable, FindSqlType(providerName)); r.Read(record => { var s = w.WriteInsert(record); return processRecord(s); }); }