yessql

yessql copied to clipboard

YesSql OrdderBy generated SQL format error.

1

Hi, if I do a ContentItem query with index, generated SQL has format error: var query = _session.Query(); query = query.With(ci => ci.Published); query.With().OrderByDescending(x => x.CreateTime); var contents = await...

RockNHawk

How to use yessql for dynamic entity not strong type?

3

KhoiNguyenICT

AWS MySql Aurora supports Autoscaling by providing a separated reader end-point. Basically Reader Endpoint load-balances connections across the pool of available Read Replicas by reducing the load on the primary...

rserj

Hi, I would like to connect to my Azure SQL Server from my Azure Web App using managed identity like it's described here: https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-connect-msi But is there any way to...

micnyk

Invalid SQL generated with multiple OrderBy calls

1

I have something like this: protected IQuery PublishedItemQuery() where TIndex : class, YesSql.Indexes.IIndex => Session.Query() .Where(q => q.Published) .OrderByDescending(q => q.CreatedUtc) .With(); When I use an additional ordering... await PublishedItemQuery()...

TimDSylvester

Change the names or case of the hardcoded Document table, index tables and the hard coded columns in config

2

Because I am using PostgreSQL, it is weird that the table names are in Pascal Case. This makes it harder to do queries directly to the database. It would be...

ngoov

Reindex

1

Once we had inserted data, and need to change or add additional indexes, is their a way to recreate all the indexes from the existing data?

dialtonetech

Reduce Index throwing "Sequence contains more than one element" error

1

Session.cs line 810 is throwing a "Sequence contains more than one element" error. The problem is happening because the GroupBy() on the same line is doing a case-sensitive grouping. But...

wedge206

IsIn fails if over 2100 values are passed :) (sqlazure)

3

The IsIn method fails in sqlserver if over 2100 values are passed to it (due to the parameter limits on sqlazure for `column IN (,)` Any chance we could intelligently...

carlwoodhouse

Might be worth adding a package description to the nuget packages... Currently this; 

Jetski5822