If you have a distributed aplication (like a mobile app), you can use
db.UserVersion to determine whether the file has to be processed or not
db.GetCollection<Setting>("settings").UpdateMany(s => new { setting.Name, setting.Value }, s => s.Name == setting.Name);
The example is
Extend expression must return an anonymous class to be merge with entities. Eg: col.UpdateMany(x => new { Name = x.Name.ToUpper() }, x => x.Age > 10)
Hi all! I have been using v5 of LiteDB with pleasure but I'm running into an issue with enums. By default enum values are serialized as strings but that won't work with Linq so I added
BsonMapper.Global.EnumAsInteger = true; to my application. That solved the problem with my "first" enum but introduced one for another enum I use. This enum is defined on my class as public DocumentType[] SupportedDocumentTypes { get; set; }
Saving is working, but when retrieving an item from the DB I get :
: 'Object cannot be stored in an array of this type.' . Contents of the DB field at the point is : [0,1]
any help would be much appreciated
@lbnascimento works like a charm! Using my local build for now, any ETA on a new nuget release ?
thanks again!
In BsonValue:
public BsonDocument AsDocument => this as BsonDocument;
Is there some kind of override that will convert a
BsonValue into a BsonDocument that I'm not seeing?
In the code I've written I've created a
BsonValue by doing new BsonValue(myBsonDocument) and it is throwing a null exception on case BsonType.Document: return this.AsDocument.GetBytesCount(recalc); during the upsert.
To be clear, the issue I'm seeing is that the above code is trying to cast the BsonValue as a BsonDocument....which I don't see how that would ever work. To answer your question:
The BsonDocument passed to the BsonValue is created like so:
BsonDocument ToBsonDocument()
{
BsonDocument retVal = new BsonDocument();
retVal["x"] = x;
retVal["y"] = y;
return retVal;
}
hey, I have an issue where my database becomes unreadable with a
It happened twice on the same of my users entries; after the first time I thought I had found the issue but a few hours later if happened again. Is there any way to see what the offending string is?
System.NotSupportedException: BSON type not supportedIt happened twice on the same of my users entries; after the first time I thought I had found the issue but a few hours later if happened again. Is there any way to see what the offending string is?
4 replies
@Floowey Could you send me your data file?
that didn't work out as I thought it would
let me know if there's anything else you need, you could also dm me on discord (Floowey#0205)
I'm trying to store Serilog's LogEvent in LiteDB, but there is an issue with fetching the objects back as the LogEvent class contains another class that has no public constructors with no parameters. So it doesn't know how to deserialize it. I solved the json Serializing/Deserializing with newtonsoft by telling newtonsoft how to deserialize that specific class, but that doesn't work for LiteDB. Any ideas on how to solve this?
I guess I could use newtonsoft to serialize it and then store it as a string, and then deserialize the string on fetch, but I'd much prefer to skip that step if at all possible somehow
What am I doing wrong here? Object reference not set to an instance of an object on serializing?
BsonMapper.Global.RegisterType<LogEvent>(
serialize: (LogEvent) => new BsonValue(JsonConvert.SerializeObject(LogEvent)),
deserialize: (BsonValue) => JsonConvert.DeserializeObject<LogEvent>(BsonValue.AsString, new LogEventJsonConverter(), new LogEventPropertyValueConverter())
);
@ASPNIC Your custom serializer converts
LogEvent to a BsonValue containing a string. While this is supported (and even useful in some instances), you won't be able to have LogEvent as the top-level object in a collection, you would only be able to use it as a sub-object.
You can't have a collection of "loose"
BsonValues like string or int, you can only insert BsonDocuments in a collection
If you want to centralize the actual serialize/deserialize logic in Newtonsoft while still being able to use the class normally in LiteDB, you could do something like this:
BsonMapper.Global.RegisterType<LogEvent>(
serialize: (LogEvent) => LiteDB.JsonSerializer.Deserialize(JsonConvert.SerializeObject(LogEvent)),
deserialize: (BsonValue) => JsonConvert.DeserializeObject<LogEvent>(BsonValue.AsDocument.ToString(), new LogEventJsonConverter(), new LogEventPropertyValueConverter())
);
I noticed that the Delete methods on both the LiteRepository and the LiteCollection do not accomodate
Delete<T>(T Entity, string collectionName) or DeleteMany<T>(IEnumerable<T> entities, string collectionName) as input. My class handles passing entities through to the LiteRepository but does not know anything about the entities passed in, so I can not get the id to pass in or to create a predicate. Is there a way to pass in an entity to be deleted?
LiteDB.LiteException: Invalid Data on 39099. Full zero: False. Page Type: Index. Prev/Next: 4294967295/4294967295. UniqueID: 20147. ShareCounter: 1.
at LiteDB.Engine.DataPage..ctor (LiteDB.Engine.PageBuffer buffer) [0x00017] in <ca87e3e06962463fb463e94e3bd88728>:0
at LiteDB.Engine.BasePage.ReadPage[T] (LiteDB.Engine.PageBuffer buffer) [0x000b7] in <ca87e3e06962463fb463e94e3bd88728>:0
at LiteDB.Engine.DataPage..ctor (LiteDB.Engine.PageBuffer buffer) [0x00017] in <ca87e3e06962463fb463e94e3bd88728>:0
at LiteDB.Engine.BasePage.ReadPage[T] (LiteDB.Engine.PageBuffer buffer) [0x000b7] in <ca87e3e06962463fb463e94e3bd88728>:0
Wbat does this mean and how can i fix ir?
@carlokok Could you send me your datafile?
(320mb)
Is there like a "recover" tool that I can use to recover it ?
Need your help on deserializing a List.
i create dynamically a query and get the result like this:
var resultSet = _store.Execute(sql).ToEnumerable().Select(s => BsonMapper.Global.Deserialize<SongData>(s)).ToList();In my SongData class i have:
public List<string> PictureHashList => _pictureHashList;Using LiteDBStudio i can see that i have values in the list, but the above query returns an empty list.
Any ideas?