search

fsprojects / FSharp.Data.SqlClient

A set of F# Type Providers for statically typed access to MS SQL database
http://fsprojects.github.io/FSharp.Data.SqlClient/
Other
205 stars 71 forks source link

Dacpac support info #406

Open Thorium opened 3 years ago

Thorium commented 3 years ago

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
smoothdeveloper commented 3 years ago

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.

Thorium commented 3 years ago

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 commented 3 years ago

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