tbertuzzi / repositoryhelpers Goto Github PK

Refactor CustomRepository by separating functionality into subclasses

Errors occur when attempting to execute commands with tables whose names are the same as SQL reserved words.

Example: SELECT * FROM Order

To fix this bug, I will make a pull request soon, using square brackets when referencing the table name.

Check the possibility of an attribute to define the field equivalent to the object's property in the database table

Update Library Documentation

When we are working with a query that will be mapped to more than one data type, we often need to specify the name of the property that separates those data types in what is returned from the SELECT. Dapper already has this implementation using the "splitOn" parameter. It would be very useful to make this option available in this framework as well.

Refactor GetProcedureDataTable to no longer need to pass parameters when sending the procedure name

can support mysql? thanks

Need insert Guid as Primary key

string sql = "INSERT INTO GuidTest(IntColumn) OUTPUT inserted.GuidColumn VALUES(1)";
SqlCommand cmd = new SqlCommand(sql, conn);
Guid guid = (Guid)cmd.ExecuteScalar();

Sample : https://stackoverflow.com/questions/1509947/scope-identity-for-guids

Make mediaType as application/json by default or as optional parameter in PostAsync, PutAsync, GetAsync and DeleteAsync.