So, this is an off-topic continuation of the thread "Can LLBLGen Pro generate interfaces?"

With all testing going ahead with the mobile application I alluded to in the other thread I have this question.

Can you now support SQLite?

Since LLbGen supports EFCore and .Netstandard I'm not sure I understand why you don't support SQLite which is "almost" ubiquitous as the local database on mobile applications.

I can see what you've said in some other thread I saw about your api engine. However, with the support of EFCore and .Netstandard, SQLite it should be do-able for mobile applications or any application that is using the EFCore and .Netstandard frameworks.

Thanks

K. L. Carter Sr.

Oh, sorry I probably should have posted this in a different forum.

Hi there,

It's not supported, I think because there isn't much request for it, as people on mobile development often go to the path of using Backend APIs. As it's much ways to extend the code, you could write your own Database DQE: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15489&StartAtMessage=0&#86378

Unfortunately I wish I had the time to write a DQE. I would otherwise.

Anyway, I hope that you will consider it. It's (SQLite) a HUGE market for the mobile platform and with Microsoft really putting a lot of resources into it, e.g. Xamarim, etc... I would think that a lot a people would be interested in your application for that use. There is only one other major player that I know of (could be more) that has this available. Devart Entity Developer/Designer. (based on T4 templates)

Thanks K. L. Carter Sr.

Thanks for the feedback. We'll take this into account for a future version

I would also like to see SqlLite support.

arschr wrote:

I would also like to see SqlLite support.

In the designer it might work, in the runtime there are serious implications, as in our engine we flip left/right joins if the user has specified them in the wrong order (which regularly happens, as it makes no difference for the engine) and sqlite doesn't support right joins.

There are also problems with the type system (or lack thereof), as there are barely any types in sqlite, so how to map those will be a challenge.

We'll see what we can do in the next version.

What about supporting VistaDB? The latest VistaDB is feature rich, supports right joins, and has a type system similar to SQL Server. I am looking for a Xamarin database solution where I could share code with the desktop / server version of an app I am supporting.

Supporting a database is a support burden so we don't take that lightly. VistaDB has no real marketshare to speak of, compared to other databases, and we therefore don't support it at this point.