mishael-o/dapper.simplesqlbuilder

A simple SQL builder for Dapper using string interpolation and fluent API for building safe static and dynamic SQL queries.

dapper.simplesqlbuilder's Issues

Any plans to separate the fluent APIs into a standalone project?

Feature request type

Other

Is your feature request related to a problem?

Can Normal Builder and Fluent Builder be published projects to NuGet package separately as two projects? I think sometimes people just want to use Normal Builder.

Describe the solution you would like

Publish Normal Builder and Fluent Builder as standalone NuGet package.

Describe alternatives you have considered

No response

Pull Request

• I would like to do a Pull Request

Code of Conduct

• I agree to follow this project's Code of Conduct

Does it have bulk insert or update?

Feature request type

Performance improvement

Is your feature request related to a problem?

No response

Describe the solution you would like

Does it have bulk insert or update? Can you give me an examlple?

Describe alternatives you have considered

No response

Pull Request

• I would like to do a Pull Request

Code of Conduct

• I agree to follow this project's Code of Conduct

ODBC parameter support

Feature request type

New feature

Is your feature request related to a problem?

This is a super cool library! I was just playing around with it and found that it doesn't seem to work for ODBC data sources. I know it's an older technology so I understand if it ends up being a won't fix. The way it treats parameters is very ugly, using ? with no differentiation between parameters. Sadly the way your library generates queries ends up being incompatible.

Describe the solution you would like

Perhaps an option could be added for ODBC support: SimpleBuilderSettings.Configure(parameterOdbcFormatting: true);

Then when the query is generated instead of inserting @p0, @p1, etc. it uses ?, ?, etc. I only took a brief look at the code so I don't know how how simple this actually would end up being in practice.

Describe alternatives you have considered

SimpleBuilderSettings.Configure(parameterNameTemplate: string.Empty, parameterPrefix: "?"); is actually pretty close although I'm not sure the string.Empty is being respected. Regardless, the appended numbers will still cause a problem.

Pull Request

• I would like to do a Pull Request

Code of Conduct

• I agree to follow this project's Code of Conduct

Dapper?

Feature request type

Other

Is your feature request related to a problem?

No response

Describe the solution you would like

I stumbled upon your library and have a simple question, does your library even need dapper that much? it looks like you only use DynamicParameters wouldn't it make more sense to have a small library like Dapper.SimpleSqlBuilder.Integration which implicitly converts from YourDynamicParameters to Dapper's DynamicParameters? your library basically is so good that it should not be tied to dapper ;)

Describe alternatives you have considered

No response

Pull Request

• I would like to do a Pull Request

Code of Conduct

• I agree to follow this project's Code of Conduct