SQLProvider

SQLProvider copied to clipboard

SqlDataProvider for SQLite works with dotnet build (.NET6) but not in Visual Studio 2022

2

**Describe the bug** A program with the `SqlDataProvider` for SQLite can be compiled with `dotnet build` (.NET SDK 6.0.102) but not in Visual Studio 2022 (17.0.7): **To Reproduce** The following...

florenzen

SubmitUpdates Operation Order

4

**Is your feature request related to a problem? Please describe.** When inserting a record with child records, there is no guarantee that the child records will be created after the...

devinlyons

Support table names with spaces

2

Some applications have table names with spaces using MSSQLSERVER provider  querying tables without spaces works, all tables with spaces in the name fail 

ieviev

.NET Core/.NET Standard support (Tracking issue)

17

I'm creating a tracking issue to help assess the status of .NET Core/.NET Standard support for SQLprovider. If people can help me define what we need to assess that would...

dsyme

**Is your feature request related to a problem? Please describe.** Outdated documentation **Describe the solution you'd like** Is it possible to update the docs for .net core section of the...

vip-ehowlett

Consider moving to Microsoft.Data.SqlClient

7

The System.Data.SqlClient nuget package is (AFAIK) obsolete. It also doesn't work with F# scripts / FSI easily. The Microsoft.Data.SqlClient library does and as I understand it is the vehicle for...

isaacabraham

Unable to load shared library 'SQLite.Interop.dll'

5

**Describe the bug** I can't get most basic example like https://fsprojects.github.io/SQLProvider/core/sqlite.html working. **To Reproduce** Steps to reproduce the behavior: 1. Create new console application. ```sh dotnet new console -lang F#...

jim108dev

Microsoft.Data.SqlClient with SSDT?

5

### Description I'm wanting to use Microsoft.Data.SqlClient with the [SSDT Provider](https://fsprojects.github.io/SQLProvider/core/mssqlssdt.html). [The documentation](https://fsprojects.github.io/SQLProvider/core/mssql.html#Using-Microsoft-Data-SqlClient-dll-instead-of-build-in-System-Data-SqlClient-dll) say I need to use `MSSQLSERVER_DYNAMIC`, but is it possible with `MSSQLSERVER_SSDT`? I've read the instructions in...

NickDarvey

**Describe the bug** SqlException "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS." returned when using a composed query when the...

simontreanor

Unexpected composed query behavior

2

**Describe the bug** When using composed queries an unexpected behavior occurs when a join is involved in a query. This results in a select with wrong values. See code examples...

halcwb