public IDocumentSession GetSession(string Database)
{
try
{
if (State == ConnectionState.Open)
{
if (Database != null)
{
if (Database.Length > 0)
{
Session = Store.OpenSession(Database);
}
}
else
{
Session = Store.OpenSession();
}
return(Session);
}
;
return(null);
}
catch (Exception ex)
{
DME_Editor.AddLogMessage("Error", "Could not Open Store Session in RavenDB " + ex.Message, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
public List <DatabaseCollection> GetDatabaseNames()
{
try
{
var operation = new GetDatabaseNamesOperation(0, 25);
string[] databaseNames = Store.Maintenance.Server.Send(operation);
Databases = new List <DatabaseCollection>();
foreach (string item in databaseNames)
{
DatabaseCollection t = new DatabaseCollection();
t.DatabasName = item;
t.Collections = GetCollection(item);
foreach (string col in t.Collections)
{
ConnProp.Entities.Add(GetEntityStructure(col.Remove(col.Length, 1), t.DatabasName));
}
}
return(Databases);
}
catch (Exception ex)
{
DME_Editor.AddLogMessage("Error", "Could not Get Databases From RavenDB " + ConnProp.ConnectionName, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
public IEnumerable <string> GetEntities(string pDatabase)
{
try
{
return(Databases.Where(x => x.DatabasName == pDatabase).FirstOrDefault().Collections);
}
catch (Exception ex)
{
string mes = "";
DME_Editor.AddLogMessage(ex.Message, "Could not retrieve entities in RavenDB " + mes, DateTime.Now, -1, mes, Errors.Failed);
return(null);
};
}
public IDocumentSession CloseSession(string Database)
{
try
{
Session.Dispose();
return(null);
}
catch (Exception ex)
{
DME_Editor.AddLogMessage("Error", "Could not Close Store Session in RavenDB " + ex.Message, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
private DataSet CreateDataset(string pDatabase)
{
ds = new DataSet();
try
{
return(ds);
}
catch (Exception ex)
{
string mes = "";
DME_Editor.AddLogMessage(ex.Message, "Could not create dataset RavenDB " + mes, DateTime.Now, -1, mes, Errors.Failed);
return(null);
};
}
public List <string> GetCollection(string Database)
{
try
{
var op = new GetCollectionStatisticsOperation();
CollectionStatistics collectionStats = Store.Maintenance.Send(op);
return(collectionStats.Collections.Keys.ToList());
}
catch (Exception ex)
{
DME_Editor.AddLogMessage(ex.Message, "Could not get Collection from Database in RavenDB " + Database, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
public IDocumentStore OpenStore(string pUrl, int pMaxNumberOfRequestsPerSession = 10, bool pUseOptimisticConcurrency = true)
{
try
{
if (ConnProp.CertificatePath != null)
{
if (ConnProp.CertificatePath.Length > 0)
{
Store = new DocumentStore()
{
Urls = new[] { pUrl, /*some additional nodes of this cluster*/ },
// Set conventions as necessary (optional)
Conventions =
{
MaxNumberOfRequestsPerSession = pMaxNumberOfRequestsPerSession,
UseOptimisticConcurrency = pUseOptimisticConcurrency
},
Certificate = new X509Certificate2(ConnProp.CertificatePath),
}.Initialize();
}
}
else
{
Store = new DocumentStore()
{
Urls = new[] { pUrl, /*some additional nodes of this cluster*/ },
// Set conventions as necessary (optional)
Conventions =
{
MaxNumberOfRequestsPerSession = pMaxNumberOfRequestsPerSession,
UseOptimisticConcurrency = pUseOptimisticConcurrency
},
}.Initialize();
}
State = ConnectionState.Open;
return(Store);
}
catch (Exception ex)
{
State = ConnectionState.Closed;
DME_Editor.AddLogMessage("Error", "Could not Open Store in RavenDB " + ex.Message, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
public EntityStructure GetEntityStructure(string DocName, string Database)
{
EntityStructure retval = new EntityStructure();
try
{
Session = GetSession(Database);
var command = new GetDocumentsCommand(DocName, null, metadataOnly: true);
Session.Advanced.RequestExecutor.Execute(command, Session.Advanced.Context);
var result = (BlittableJsonReaderObject)command.Result.Results[0];
var documentMetadata = (BlittableJsonReaderObject)result["@metadata"];
// Print out all the metadata properties.
EntityStructure entityData = new EntityStructure();
string sheetname;
sheetname = DocName;
entityData.EntityName = DocName;
entityData.DataSourceID = ConnProp.ConnectionName;
entityData.SchemaOrOwnerOrDatabase = Database;
List <EntityField> Fields = new List <EntityField>();
int y = 0;
foreach (var propertyName in documentMetadata.GetPropertyNames())
{
documentMetadata.TryGet <object>(propertyName, out var metaPropValue);
EntityField f = new EntityField();
f.fieldname = propertyName;
f.fieldtype = "System.String";
f.FoundValue = false;
f.EntityName = sheetname;
f.FieldIndex = y;
Fields.Add(f);
y += 1;
}
return(retval);
}
catch (Exception ex)
{
DME_Editor.AddLogMessage(ex.Message, "Could not Create Entity structure for RavenDB Entity " + DocName, DateTime.Now, -1, ConnProp.Url, Errors.Failed);
return(null);
}
}
public List <string> GetEntitesList()
{
try
{
// List<EntityStructure> entlist = new List<EntityStructure>();
Entities = new List <string>();
Entities = Reader.GetEntities(CurrentDatabase).ToList();
// DME_Editor.ConfigEditor.DataConnections.Where(c => c.FileName == DatasourceName).FirstOrDefault().Entities =entlist ;
Logger.WriteLog("Successfully Retrieve Entites list ");
}
catch (Exception ex)
{
string mes = "";
DME_Editor.AddLogMessage(ex.Message, "Could not Open Store in RavenDB " + mes, DateTime.Now, -1, mes, Errors.Failed);
};
return(Entities);
}
public bool WriteDocumentToStore <T>(string pDatabase, T MyObject)
{
try
{
using (var session = Store.OpenAsyncSession(new SessionOptions
{
//default is: TransactionMode.SingleNode
TransactionMode = TransactionMode.ClusterWide,
Database = pDatabase
}))
{
//var user = new Employee
//{
// FirstName = "John",
// LastName = "Doe"
//};
session.StoreAsync(MyObject);
// this transaction is now conditional on this being
// successfully created (so, no other users with this name)
// it also creates an association to the new user's id
//session.Advanced.ClusterTransaction
// .CreateCompareExchangeValue("usernames/John", user.Id);
session.SaveChangesAsync();
}
return(true);
}
catch (Exception ex)
{
string mes = "";
DME_Editor.AddLogMessage(ex.Message, "Could not Store Document Store in RavenDB " + mes, DateTime.Now, -1, mes, Errors.Failed);
return(false);
};
}
