ServiceStack.OrmLite | Fast , Simple , Typed ORM for .NET | Database library

I'm using ServiceStack.OrmLite, and when trying to set the default column definition for DateTime, I can’t manage to get the column to be nullable. Everything else sticks, but "NULL" is somehow converted into "NOT NULL".

In my example code below I've set ColumnDefinition => "DATETIME(6) NULL DEFAULT... and when running it, it creates a table with DATETIME(6) NOT NULL...

I have updated ServiceStack to latest version on a project and now this line seems to be giving me issues:

After installing ServiceStack.OrmLite.SqlServer NuGet Packages, I started getting below error out of no clue.

I've made a custom auth provider for LDAP (Active Directory) based on the CredentialsAuthProvider. Following the docs I've overridden TryAuthenticate and OnAuthenticated, returning true at the end. I've also tried without OnAuthenticated.

I'm using UseDistinctRoleTables for the OrmLiteAuthRepository, and I've observed in the tables that roles are being created in UserRole.

However I'm getting the exception: ArgumentNullException. Fieldname "s".

I started a ServiceStack ASP.NET Empty project in VS2019, as that was the closest thing I could find to what I wanted. The template is right on, but I want to run it in .NET Core.

However, the Target framework was set to .NET Framework 4.5, but I wanted it to be .NET Core 2.1+, and I cannot select it either:

I know that I have .NET Core installed, because I have been developing a Blazor app also in VS2019, which is .NET Core.

I'd like to know what I am missing here.

Here is the csproj file for the project containing the AppHost.cs

I get a runtime error when using ServiceStack.OrmLite.Core package (5.4.1) and trying to get a ModelDefinition (ServiceStack.OrmLite.ModelDefinition) by doing:

I am posting this question here, as I'm still waiting for approval on the ServiceStack customer forum. It's a rather specific question, so I don't expect many can help... @mythz :)

I'm migrating ServiceStack from v5.4 to v5.7 and there is an issue with aliases in SqlExpression.

I wrote a custom sql concat to get a "kind-of-csv-format" in one column, to merge data into one column, when using unions. From the SQL side, simplified version would be:

I have an implementation, where I am calling an autoquery operation via the service gateway. The service gateway will successfully call both internal and external operations. However, any autoquery operation fails because it is not getting the connection string set. These same autoquery operations work just fine when called directly and not through the gateway.

Here is the stack trace.

To elaborate what I try to achieve with servicestack.ormlite. Imagine that a franchise business has some branches, each branch has system and local database, all of these database are replicating each other. In the system, each model is with a property called store_id like below.