Add user defined function call support for MSSQL

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

564 stars 144 forks source link

Add user defined function call support for MSSQL #781

Open MMagueta opened 1 year ago

MMagueta commented 1 year ago

Proposed Changes

WIP

Types of changes

[ ] Bugfix (non-breaking change which fixes an issue)
[X] New feature (non-breaking change which adds functionality)
[ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)

Checklist

[ ] Build and tests pass locally
[ ] I have added tests that prove my fix is effective or that my feature works (if appropriate)
[ ] I have added necessary documentation (if appropriate)

Further comments

WIP

MMagueta commented 1 year ago

Status:

[X] Parse the XML for a scalar function and inline table functions
[X] Add callable reference on F#
[ ] Check parameters for inlined tables and other not so primitive types, such as XML
[ ] Tests

MMagueta commented 1 year ago

@JordanMarr I am facing a problem that you might have a field view wider than I do. XML fields are simply not being translated to XElement. A procedure/function/UDDT that has an XML type exposed simply does not get designed, not resulting in an overall failure, the rest continues to work just fine. I did confirm that System.Xml.Linq.XElement is on the map for the TSQL correspondence. Any ideas of how to assess this?

JordanMarr commented 1 year ago

Is this question related to the SSDT parser? If so, it might be helpful if you added the sqlproj to the test sln with a broken test to highlight the issue.