LLBLGen Pro Support System Feature requests feed

JSON/Vector data type support for SQL Server 2025 by Otis

Otis — Wed, 18 Mar 2026 08:19:34 GMT

DvK wrote:

OK, that's a pity. I thought EF Core supports it, so LLBLGen will as well.

IIRC EF Core supports json types indeed, don't think they support vector (yet). A long time ago we decided not to add xpath, json and the like types unless it's possible to query them with parameters, but no database has implemented it that way, so we don't support them in our runtime.

JSON/Vector data type support for SQL Server 2025 by DvK

DvK — Wed, 18 Mar 2026 07:50:16 GMT

OK, that's a pity. I thought EF Core supports it, so LLBLGen will as well.

JSON/Vector data type support for SQL Server 2025 by Otis

Otis — Wed, 18 Mar 2026 07:14:51 GMT

We don't support json types because querying requires the predicate to be embedded into the sql string (same reason as with xpath) . For vector types, we have to think about it, but I doubt we'll do it.

JSON/Vector data type support for SQL Server 2025 by DvK

DvK — Tue, 17 Mar 2026 15:23:32 GMT

Hi,

Just wanted to inform about supporting the new JSON and Vector datatypes for SQL Server 2025, any chance of getting this into future releases?

https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type https://learn.microsoft.com/en-us/sql/t-sql/data-types/vector-data-type

Best regards, Danny

Linq support for STRING_AGG by Otis

Otis — Tue, 10 Feb 2026 07:03:48 GMT

TomDog wrote:

Any update on this?

We decided not to implement this as this is very problematic, as the requirement to deal with the query is to break it down to just the projection and inline that inside the function. This means that the query:

var q = from c in metaData.Customer
group c by c.Country
into g
select new
{ Country = g.Key, Cities = string.Join(",", g.Select(x => x.City)) };

Can't be translated directly, we have to interpret the g.Select() because it's inside the string join and can't be converted into a query as that would result in a scalar query inside the function call. We thus have to break down the scalar query into just a projection and place it inside the function call. Our system doesn't work that way as it doesn't know what function the query is used in. (as that's converted after the elements have been converted, i.e. at the very end)

Linq support for STRING_AGG by TomDog

TomDog — Mon, 09 Feb 2026 14:18:06 GMT

Any update on this?

.Net 10 by Otis

Otis — Thu, 13 Nov 2025 08:16:19 GMT

We'll add LeftJoin/RightJoin support soon, but the breaking change Microsoft introduced silently was fixed yesterday indeed.

.Net 10 by yowl

yowl — Wed, 12 Nov 2025 13:53:37 GMT

Sorry, should have read the other thread first, will try the hotfix.

.Net 10 by yowl

yowl — Wed, 12 Nov 2025 13:51:07 GMT

Hi, Just out yesterday, but is there any ETA for an update that supports .net 10, seems like there are quite a lot of changes around the Linq area?

Thanks

Nullable reference types option by Otis

Otis — Thu, 16 Oct 2025 07:21:34 GMT

We'll think about it!