isn't dbref for referencing collections within the same db?
@captmomo The most common way to manipulate data in LiteDB is using
LiteCollection<T>. For example, if you have two classes Customer and Product, you would open two distinct collections: var customerCol = db.GetCollection<Customer>(); and var productCol = db.GetCollection<Product>();
@captmomo If you want a single "entry point" for all your data, that's when you use
LiteRepository. Internally, it still uses distinct collections, but you can simply throw all your objects at it and it will handle the collections itself.
@captmomo Now, imagine you have a property of type
Product inside Customer. LiteDB will store Product as a sub-document inside Customer, so they'll both be stored in the Customer collection. By using DbRef, you can store instances of Product in its own collection and store only a reference to it in every customer. This, however, should not be used with LiteRepository.
I switched to using collection and it's still throwing the error.
@captmomo Yeah, my explanation wasn't particularly clear, sorry about that. The default behavior of LiteDB is to store sub-objects as embedded documents.
DbRef allows you to override this behavior, but it changes the "expected" collection structure. If you want to use LiteRepository, you should let it decide on the correct way to store things.
i swtiched to just storing the id of the user instead of a ref, everything seems to be working now
How does the LiteDb IQueryable Skip work with Limit?
If I have 50 entries. and I have a query like:
UserGenerator userGenerator = new UserGenerator();
while (count <= 10)
{
User newUser = userGenerator.Generate();
newUser.Name = "test";
context.LiteRepository.Insert(newUser);
count++;
testing.Add(newUser);
}
var user = context.LiteRepository.FirstOrDefault<User>(x => x.Name == "test");
var users = context.LiteRepository.Query<User>().Where(x => x.Name == "test").Skip(1).Limit(5).ToList();The first query gives me a user with Id = 9, the second query gives me users with ids from 6 to 11.
Is my query syntax incorrect?
Newtonsoft.Json.JsonSerializationException: Error getting value from 'AsDateTime' on 'LiteDB.BsonValue'.
---> System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.DateTime'.
at lambda_method(Closure , Object )
Getting this issue with this class when serializing:
The JsonConvert is from NewtonSoft, could that be an issue?
internal async Task<IEnumerable<LogMessage>> ProcessLogEvents(IEnumerable<LogEvent> logEvents, int clientId)
{
List<LogMessage> messages = new List<LogMessage>();
foreach (var evt in logEvents)
{
var logMessage = new LogMessage()
{
Level = evt.Level,
Message = evt.RenderMessage(),
TimeStamp = evt.Timestamp,
UserId = clientId
};
if (evt.Exception != null)
{
logMessage.Exception = evt.Exception.ToString();
}
if (evt.Properties.Any())
{
string complete = await Task.Run(() => Newtonsoft.Json.JsonConvert.SerializeObject(evt.Properties));
logMessage.Properties = LiteDB.JsonSerializer.Deserialize(complete).AsDocument;
}
messages.Add(logMessage);
}
return messages;
}//retrieval
return _repository.Query<T>()
.OrderBy(x => x.Id, order: Query.Descending)
.Where(predicate)
.Skip(skip)
.Limit(take)
.ToList();
the error happens when I return the ActionResult
the last step
I see you're deserializing
LogEvent.Properties with NewtonSoft.Json and serializing it right after with LiteDB.JsonSerializer, there's probably some form of incompatibility (I believe Newtonsoft serializes dates as strings, while LiteDB serializes them to a custom document)
properties*
{{"custom":{"TypeTag":null,"Properties":[{"Name":"message","Value":{"Value":"Yesenia-orange"}}]},"SourceContext":{"Value":"Sample.Program"},"Application":{"Value":"Sample"}}}
{{"SourceContext":{"Value":"Sample.Program"},"Application":{"Value":"Sample"}}}
i.e the value of custom is a string, and I cant access the properties.
using a bsondocument, i can do Properties.Custom.TypeTag
if I use dictionary<string, string> i need to do a json(properties.custom) then access the properties
//retrieval
return _repository.Query<T>()
.OrderBy(x => x.Id, order: Query.Descending)
.Where(predicate)
.Skip(skip)
.Limit(take)
.ToList(); var results = getLogMessages();
return Ok(results);