internal ISyncDigestTableAdapter CreateSyncDigestTableAdapter(IResourceKindTableAdapter resourceKindTableAdapter, IEndpointTableAdapter endpointTableAdapter)
{
ISyncDigestTable syncDigestTable = new SyncDigestTable(resourceKindTableAdapter.Table, endpointTableAdapter.Table);
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
// create the table
if (!JetHelpers.TableExists(syncDigestTable.TableName, jetTransaction))
{
syncDigestTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
else
{
// update the table
ITableFieldsUpdated tableFieldUpdater = syncDigestTable as ITableFieldsUpdated;
if (null != tableFieldUpdater)
{
tableFieldUpdater.UpdateFields(jetTransaction);
jetTransaction.Commit();
}
}
}
return(new SyncDigestTableAdapter(syncDigestTable, _context));
}
public bool Get(int resourceKindId, out byte[] applicationBookmark, out string assemblyQualifiedName, IJetTransaction jetTransaction)
{
applicationBookmark = null;
assemblyQualifiedName = null;
OleDbCommand oleDbCommand = jetTransaction.CreateOleCommand();
string sqlQuery = string.Empty;
sqlQuery = "SELECT [Type], [Value] FROM {0} WHERE [FKResourceKindId] = @ResourceKindId";
oleDbCommand.CommandText = string.Format(sqlQuery, _appBookmarkTable.TableName);
oleDbCommand.Parameters.AddWithValue("@ResourceKindId", resourceKindId);
OleDbDataReader reader = oleDbCommand.ExecuteReader(CommandBehavior.SingleRow | CommandBehavior.SequentialAccess);
if (!reader.HasRows)
{
return(false);
}
reader.Read(); // only one row accepted
assemblyQualifiedName = Convert.ToString(reader["Type"]);
applicationBookmark = JetHelpers.ReadBlob(reader, 1);
return(true);
}
internal IEndpointTableAdapter CreateEndpointTableAdapter()
{
IEndpointTable endpointTable = new EndpointTable();
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
if (!JetHelpers.TableExists(endpointTable.TableName, jetTransaction))
{
endpointTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
}
IEndpointTableAdapter endpointTableAdapter = new EndpointTableAdapter(endpointTable, _context);
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
endpointTableAdapter.SetOriginEndPoint(_context.BaseUrl, jetTransaction);
jetTransaction.Commit();
}
return(endpointTableAdapter);
//CachedEndpointTableAdapter cachedEndpointTableAdapter = new CachedEndpointTableAdapter(endpointTableAdapter);
//using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
//{
// cachedEndpointTableAdapter.Load(jetTransaction);
// jetTransaction.Commit();
//}
//return cachedEndpointTableAdapter;
}
internal IResourceKindTableAdapter CreateResourceKindTableAdapter()
{
IResourceKindTable resourceKindTable = new ResourceKindTable();
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
if (!JetHelpers.TableExists(resourceKindTable.TableName, jetTransaction))
{
resourceKindTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
}
IResourceKindTableAdapter resourceKindTableAdapter = new ResourceKindTableAdapter(resourceKindTable, _context);
return(resourceKindTableAdapter);
//CachedResourceKindTableAdapter cachedResourceKindTableAdapter = new CachedResourceKindTableAdapter(resourceKindTableAdapter);
//using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
//{
// cachedResourceKindTableAdapter.Load(jetTransaction);
// jetTransaction.Commit();
//}
//return cachedResourceKindTableAdapter;
}
internal ITickTableAdapter CreateTickTableAdapter(IResourceKindTableAdapter resourceKindTableAdapter)
{
ITickTable tickTable = new TickTable(resourceKindTableAdapter.Table);
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
if (!JetHelpers.TableExists(tickTable.TableName, jetTransaction))
{
tickTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
}
return(new TickTableAdapter(tickTable, _context));
}
internal ISyncResultsTableAdapter CreateSyncResultsTableAdapter(string resourceKind, IResourceKindTableAdapter resourceKindTableAdapter)
{
ResourceKindInfo resourceKindInfo = null;
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
jetTransaction.Commit();
}
ISyncResultsTable syncResultsTable = new SyncResultsTable(resourceKindInfo.Id, resourceKindTableAdapter.Table);
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
if (!JetHelpers.TableExists(syncResultsTable.TableName, jetTransaction))
{
syncResultsTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
}
return(new SyncResultsTableAdapter(syncResultsTable, _context));
}
internal ICorrelatedResSyncTableAdapter CreateCorrelatedResSyncTableAdapter(string resourceKind, IEndpointTableAdapter endpointTableAdapter, IResourceKindTableAdapter resourceKindTableAdapter)
{
ResourceKindInfo resourceKindInfo = null;
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
jetTransaction.Commit();
}
ICorrelatedResSyncTable correlatedResSyncTable = new CorrelatedResSyncTable(resourceKindInfo.Id, resourceKindTableAdapter.Table, endpointTableAdapter.Table);
using (IJetTransaction jetTransaction = _connProvider.GetTransaction(false))
{
if (!JetHelpers.TableExists(correlatedResSyncTable.TableName, jetTransaction))
{
correlatedResSyncTable.CreateTable(jetTransaction);
jetTransaction.Commit();
}
}
return(new CorrelatedResSyncTableAdapter(correlatedResSyncTable, _context));
}
