Is it possible to pull down a partial row and then update it?

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.

https://fsprojects.github.io/SQLProvider

Other

580 stars 146 forks source link

Is it possible to pull down a partial row and then update it? #804

Closed JordanMarr closed 1 year ago

JordanMarr commented 1 year ago

Hi @Thorium,

This is more of a question than a bug.

I have a table with a large json column.
I want to pull that record and make some updates to the other columns, but I don't want to pull down the json column because it's really big and I don't need to touch it. The problem is that if I select a subset of columns into a projection, then I can no longer update the columns. Is there a way to do this, or maybe a workaround?

Thorium commented 1 year ago

A little bit hack, but yes: https://github.com/fsprojects/SQLProvider/issues/561#issuecomment-404956768