public async virtual Task <ReturnType> SelectByID <ReturnType>(CrudBaseModels.PrimaryKeyGuid id) { using IDbConnection dbConnection = new SqlConnection(ConnectionString); if (dbConnection.State == ConnectionState.Closed) { dbConnection.Open(); } DynamicParameters parameter = new DynamicParameters(); parameter.Add($"@{tableName}ID", id); return(await dbConnection.QueryFirstOrDefaultAsync <ReturnType>($"[{schemaName}].APP_SP_SEL_{tableName}_ByID", parameter, commandType : CommandType.StoredProcedure)); }
public async virtual Task <int> Delete(CrudBaseModels.PrimaryKeyGuid id) => await ExecuteStoredProcedureFirstOrDefaultAsync <Guid, int>($"[{schemaName}].APP_SP_DEL_{tableName}", id);