I am writing an application in C#.NET. I need to use a SQL compliant single file db like sqlite. I can't use sqlite because it is extremely odd way of storing dates in UTC instead of localtime. Also its support for date operations relies on Julianized date format which is not easy for end-user to grasp at all.
I wish I could use MS-Access, but I guess the end user will have to have MS-Access on their machine to run the application, which is not something I can ask them for.
It is important for me to have near zero install experience.
I took a look at H2 but I am not sure how easy it is to run with .NET and I did not see any browser for it.
The database is expected to be used by 5 users at most for read and 1 user for write at any given time. The largest volume may not exceed 100000 rows in 5 tables.
I would like the solution to be royalty free, even if the product itself is not free.