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
570 stars 144 forks source link

Deleted row count for Seq.``delete all items from single table`` #633

Open thosomers opened 4 years ago

thosomers commented 4 years ago

Description

executeDeleteQueryAsync in SqlRuntime.Linq.fs doesn't return deleted row count.

Repro steps

Seq.delete all items from single table always returns 0.

Expected behavior

Seq.delete all items from single table should return the number of rows deleted.

Known workarounds

Use cmd.ExecuteNonQueryAsync instead of cmd.ExecuteScalarAsync

Thorium commented 4 years ago

Sounds like a fair request, and doable. :-)