DateTime field or even make it your Id field. Due to the BSON spec, LiteDB only stores dates up to the miliseconds (losing a bit of precision). There is a simple workaround for that though, so let me know if you need help with that.
:memory: as its datafile or by using the LiteDatabase ctor that takes a Stream (you can pass a MemoryStream to it)
@raizam You can create an index over a
DateTimefield or even make it your Id field. Due to the BSON spec, LiteDB only stores dates up to the miliseconds (losing a bit of precision). There is a simple workaround for that though, so let me know if you need help with that.
will the DateTime order be preserved when I'll iterate the records? in both indexed/key scenarios?
db.Execute("select $._id from collection").ToList(). This will give you a list of BsonDocuments containing the id
var ids = db.Execute("select $._id from collection").ToEnumerable().Select(doc => doc["_id"].AsInt32).ToList(); (assuming the id is Int32)
DbRef
.ToList() or .ToArray(), then all the documents in the collection will be loaded into memory.
@lbnascimento explained well how LiteDB works under the hood,
Since I made a big refactor and all my queries are based on predicates, I am stuck for more than 3 weeks, can someone help me to find a solution for this situation,
Did someone manage how to combine two predicate and use it in LiteDB ?
thanks developers ---- issue: #1829
Is it possible to use the following expression with LiteDB?
return maintenanceAssetCollection.UpdateMany(_ =>
new MaintainableAssetEntity()
{
AttributeDatumEntities = new List<IAttributeDatumEntity>(),
Id = _.Id,
LocationEntity = _.LocationEntity,
NetworkId = _.NetworkId
},
_ => _.NetworkId == networkId);I keep getting a runtime NotSupported exception. When I change the list assignment to null it works.
Ah, I changed the code to this and it seemed to work:
return maintenanceAssetCollection.UpdateMany(_ =>
new MaintainableAssetEntity()
{
AttributeDatumEntities = new List<IAttributeDatumEntity>() { },
Id = _.Id,
LocationEntity = _.LocationEntity,
NetworkId = _.NetworkId
},
_ => _.NetworkId == networkId);Note the curly brackets in the new list expression are the change.
Hi, I can not find any way to use expressions and functions: https://www.litedb.org/api/functions/ https://www.litedb.org/docs/expressions/
how can I do that?
suppose I have a collection CalledFinancialContractCollection contains Contracts
public class FinancialContract : ReactiveObject, IHotHostReloaded<FinancialContract>
{
[BsonId] public ObjectId Id { get; set; }
public string PersonName { get; set; }
public string PersonIdNumber { get; set; }
public DateTime StartDate { get; set; }
}How can I get the recent Contract with depends on StartDate by using Functions | Expressions
The problem is i can not find anything in the documentation descripe how to use it, the only example is with indices
And take this example from expressions page
SELECT { upper_titles: ARRAY(UPPER($.Books[*].Title)) } WHERE $.Name LIKE "John%"How can i execute this from c# ??
Please Helpe me.
WebAPi hosted, I have write permissions, a test file is written regularly.
Hi everyone
I'm trying to use LiteDB (net45) in Unity 2019 targeting an ARM device. The sample application to perform CRUD operations works fine in the editor but in the device I'm getting this exception:
System.NotSupportedException: Invalid BsonExpression when converted from Linq expression: x => x.Name - `$.Name` ---> System.TypeInitializationException: The type initializer for 'LiteDB.BsonExpression' threw an exception. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: methodI did some googling and found a stack overflow question asking about this, in which the one answer states that this could be due to missing dependencies. However, I am using the .NETFramework 4.5 DLL which according to the NuGet page does not have any dependencies.
Has anyone faced this issue? If so can someone let me know how I can address this?
