Mongodb support

[guidoDimasi]

using EF is it supported to use MongoDb as database on the server?

[adrianhall]

I haven't seen an implementation using MongoDB, however all the facilities are available to support it. You will probably have to create your own version of the EntityTableData that explicitly supports the requirements of MongoDB.

Failing that, you can write your own repository for MongoDB, assuming the .NET driver for MongoDB supports IQueryable, you should have no problem.

Try it and let us know how you get on! If you have problems, publish a public repo with your work and we'll see how to help.

[guidoDimasi]

and if insted i'm gonna use litedb (the main reason is that when working on mobile i wanna think about "collection" and not "table") can be scaled from 10 to 100+ (not over 200 normaly) end mobile user? i'm worried about possible bottleneck.

[adrianhall]

I've got people running datasync against SQL databases with tens of thousands of users. I don't know what the scalability of LiteDb is - it's file based, so it depends on the server and concurrency limits.

I personally would not use LiteDb in production.

[guidoDimasi]

i've made as you suggested write my own version of EntityTableData and so far it seems to work well (i'm in a earlyy stage of development)

  public class   MongoDBEntity : EntityTableData
  {
      [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
      [UpdatedByRepository]
      public override DateTimeOffset? UpdatedAt { get; set; } = DateTimeOffset.UnixEpoch;

      [Timestamp]
      [UpdatedByRepository]
      public override byte[] Version { get; set; } = Array.Empty<byte>();
  }

[adrianhall]

I've created a new MongoDB Driver for 9.0.0 - the database structure may NOT be the same as the EF Core one, so bear that in mind. Mongo has not created a driver for EF Core 9.x yet (it's in progress) so you will want to decide on whether to switch or wait when 9.0.0 comes out.

[guidoDimasi]

At the moment, I have partially abandoned the idea of proceeding with MongoDB on the server due to the inability to manage more complex data on the client side (SQLite would fail to save a complex entity that is supported by Mongo on the server). I was considering trying to create a version of the client using LiteDB in the future to see how it performs. For now, I am using SQL Server and SQLite for my main project.