search

H7O / Com.H.Data.Common

Adds ExecuteQuery and ExecuteQueryAsync extension methods to DbConntion and DbCommand that returns dynamic data results IEnumerable<dynamic> and IAsyncEnumerableIEnumerable<dynamic>.
MIT License
0 stars 0 forks source link

Other databases have issues, such as Oracle, whose symbol for parameterization is not '@'. #1

Open Charleey opened 5 months ago

Charleey commented 5 months ago
1
H7O commented 5 months ago

Many thanks for reporting this! Will hopefully offer an option to change the default parameterization string format so people could change it to fit the database they're targeting.

H7O commented 5 months ago

@Charleey I've added the option to set the default parameter prefix. Here is an example of how to set that for Oracle database.

Com.H.Data.Common.AdoNetExt.DefaultParameterPrefix = ":";

The NuGet package for this library has also been updated to offer this option - link to Com.H.Data.Common at NuGet

Let me know if you face further issues with Oracle (or any other database) using this library.