yessql

yessql copied to clipboard

Drop column for Sqlite

3

Drop column is currently failing on SqLite. Need to investigate whether we can add support for the newer versions which apparently support it https://stackoverflow.com/questions/8442147/how-to-delete-or-add-column-in-sqlite

deanmarcussen

Improve readability of parameters in the recently changed SchemaBuilder interface

1

I'm learning Orchard CMS and using most recent versions of OrchardCore Preview. I tried to create and index migration logic with ISchemaBuilder.CreateMapIndexTable and ISchemaBuilder.AlterTable like it was done in the...

optiklab

DROP INDEX < SQL Server 2016

1

Currently it doesn't work because of the syntax we use. ```SQL -- Old block of code : what would work for all SQL Server versions IF EXISTS (SELECT * FROM...

Skrypt

Say I've adding a new `ReduceIndex` when there are already some existing documents in the database/store. How do I replay existing data so that this `ReduceIndex` is created that takes...

mustakimali

[Question] Is it possible to add an attribute to a property to ignore it on save?

7

i.e. : ```csharp public class BlogPost { public string Title { get; set; } public string Author { get; set; } public string Content { get; set; } public DateTime...

PizzaConsole

How much data can be stored in Document? And efficiency!

chdq0306

Would be nice if you turned on C# 8 nullables so external libs know what they are dealing with

Jetski5822

SQL server has in-memory optimized tables, which are tables stored entirely in RAM but still persisted to the storage, see some details [here](https://www.red-gate.com/simple-talk/sql/sql-development/beginner-guide-to-in-memory-optimized-tables-in-sql-server/). Such tables can offer much better performance,...

Piedone

Using a character in any of the `.Contains()` or `StartsWith()` methods throws an Invalid operation exception - Operation is not valid due to the current state of the object Just...

deanmarcussen

I have two collections, Locations and Payloads; If I execute two queries in the same session on the same request I will get Unable to cast object of type 'Tesco.HRAM.APIAdaptor.Colleagues.Models.ColleagueContractualShifts'...

Jetski5822