Jandev / Jandev/azurefunctions-sqlbinding
Add output binding to update or insert records
- Dominant language
- C#
- Stars
- 4
- Forks
- 4
- PR merge metrics
- No merged PRs in 30d
Description
To have an outputbinding for SQL is still on my list.
At the moment only `SELECT` is supported, because there's only an Inputbinding.
Being able to do an `INSERT`, `UPDATE` and maybe even `DELETE` would be awesome by using an output binding. To do this safely and dynamically can be quite difficult.
I'm thinking of using the `dynamic` or `ExpandoObject` for this and a SQL query with parameterized values. If you have other suggestions, feel free to discuss or implement them.
Keep in mind, the package needs to be as light as possible, so adding (micro) ORM's isn't ideal. We want to keep the footprint of this binding as small as possible.
Contributor guide
Research direction
Start by reading the existing SELECT and input-binding implementation; the issue names no files or tests. Before implementation, agree on the output-binding API, supported INSERT/UPDATE/DELETE behavior, parameter handling, and how to preserve the package's lightweight footprint. Done means a decided design and documented, tested support for the agreed operations.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, csharp, sql
- Domain
- backend, cloud, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100