Jandev / Jandev/azurefunctions-sqlbinding

Add output binding to update or insert records

Open
#6 0 comments 0 reactions 0 assignees View on GitHub
enhancement help wanted
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.