FSharp.Data.SqlClient icon indicating copy to clipboard operation
FSharp.Data.SqlClient copied to clipboard

Dacpac support info

Open Thorium opened this issue 4 years ago • 3 comments

Hi,

@JordanMarr has created dacpac-support to SQLProvider.

The parsing code has been separated to different files so that you can reference them directly, if you'd like to also build a support for dacpac:

https://github.com/fsprojects/SQLProvider/blob/master/src/SQLProvider/Ssdt.Polyfills.fs https://github.com/fsprojects/SQLProvider/blob/master/src/SQLProvider/Ssdt.DacpacParser.fs

If you want to easily include them into your project and still get our updates when you want, just use them as file-references in the paket.dependencies:

group SourceFiles
    source https://nuget.org/api/v2

    github fsprojects/SQLProvider src/SQLProvider/Ssdt.Polyfills.fs
    github fsprojects/SQLProvider src/SQLProvider/Ssdt.DacpacParser.fs

Thorium avatar Feb 14 '21 08:02 Thorium

Thanks @Thorium! (the code files seems to have moved)

I'm not familiar with dacpac, I think I've used the API for schema diffing and that's it.

Could you point to us some samples of the consuming code? it would help others engage in discussion about the API and features, maybe this is worth putting a separate project for if dacpac is a big thing in SQL Server ecosystem.

smoothdeveloper avatar Apr 10 '21 04:04 smoothdeveloper

https://github.com/fsprojects/SQLProvider/blob/master/src/SQLProvider.Runtime/Ssdt.DacpacParser.fs

...is the new location. Polyfills was just for old F# compatibility, not needed.

Thorium avatar Apr 10 '21 07:04 Thorium

The consuming code is here: https://github.com/fsprojects/SQLProvider/blob/master/src/SQLProvider.Runtime/Providers.MsSqlServer.Ssdt.fs

Thorium avatar Apr 10 '21 07:04 Thorium