public ReplicateToSqlIndexUpdateBatcher(
DbProviderFactory providerFactory,
string connectionString,
IndexReplicationDestination destination)
{
_providerFactory = providerFactory;
_connectionString = connectionString;
this.destination = destination;
}
static void Main()
{
var store = new DocumentStore
{
Url = "http://localhost:8080",
DefaultDatabase = "ReplicationDB"
}.Initialize();
IndexCreation.CreateIndexes(typeof(CustomersListIndex).Assembly, store);
using (var session = store.OpenSession())
{
var customers = DummyCustomers(30);
foreach (var customer in customers)
{
session.Store(customer);
}
session.SaveChanges();
}
var replication = new IndexReplicationDestination
{
Id = "Raven/IndexReplication/CustomersListIndex",
ColumnsMapping =
{
{ "FullName", "FullName" },
{ "JoinAt", "JoinedAt" },
},
ConnectionStringName = "SqlReplication",
PrimaryKeyColumnName = "Id",
TableName = "Customers"
};
store.DatabaseCommands.EnsureDatabaseExists("ReplicationDB");
using (var session = store.OpenSession())
{
session.Store(replication);
session.SaveChanges();
}
}
public static IndexReplicationDestination Create_IR_Mapping()
{
//Create replication
//The target table is OrderItem {OrderItemId, Description}
var ip = new IndexReplicationDestination
{
Id = "Raven/IndexReplication/IR/OrderItem",
ColumnsMapping =
{
{ "Description", "Description" },
{ "OrderItemId", "OrderItemId" },
},
ConnectionStringName = FactIfSqlServerIsAvailable.ConnectionStringSettings.Name,
PrimaryKeyColumnName = "DocumentId",
TableName = "OrderItem"
};
return(ip);
}
public ReplicateToSqlIndexUpdateBatcher(DbConnection connection, IndexReplicationDestination destination)
{
this.connection = connection;
this.destination = destination;
}
