Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enhancement: Add the attribute-based parameter setters for the DbParameter object. #886

Closed
mikependon opened this issue Sep 13, 2021 · 3 comments
Closed

Enhancement: Add the attribute-based parameter setters for the DbParameter object. #886

mikependon opened this issue Sep 13, 2021 · 3 comments
Assignees
@mikependon
Labels
deployed Feature or bug is deployed at the current release enhancement New feature or request fixed The bug, issue, incident has been fixed. priority Top priority feature or things to do todo Things to be done in the future

Comments

@mikependon
Copy link
Owner

mikependon commented Sep 13, 2021 •
edited
Loading

Describe the enhancement

To further support the setting of most properties of the DbParameter object before the actual execution, please add following attributes.

Usage

public class EntityClass
{
      [DbTypeAttribute(DbType.String)]
      [DirectionAttribute(ParameterDirection.Input)]
      [NameAttribute("CompleteName")]
      [PrecisionAttribute(1)]
      [ScaleAttribute(10)]
      [SizeAttribute(256)]
      public string Name { get; set; }
}

DbParameter

Add the following attributes.

  • DbTypeAttribute
  • DirectionAttribute
  • IsNullableAttribute
  • NameAttribute
  • PrecisionAttribute
  • ScaleAttribute
  • SizeAttribute

All the mentioned attributes must inherit from the PropertyValueAttribute attribute.

SqlParameter (SQL Server)

  • CompareInfoAttribute
  • DataTypeNameAttribute
  • ForceColumnEncryptionAttribute
  • LocaleIdAttribute
  • OffsetAttribute
  • SqlDbTypeAttribute
  • XmlSchemaCollectionNameAttribute
  • XmlSchemaCollectionDatabaseAttribute
  • XmlSchemaCollectionOwningSchemaAttribute

NpgsqlParameter (PostgreSQL)

  • ConvertedValueAttribute
  • DataTypeNameAttribute
  • NpgsqlDbTypeAttribute

MySqlParameter (MySQL)

  • MySqlDbTypeAttribute

MySqlParameter (MySQL Connector)

  • MySqlDbTypeAttribute

SQLiteParameter (System)

  • TypeNameAttribute

SqliteParameter (Microsoft)

  • SqliteTypeAttribute
@mikependon mikependon added the enhancement New feature or request label Sep 13, 2021
@mikependon mikependon self-assigned this Sep 13, 2021
mikependon added a commit that referenced this issue Sep 13, 2021
@mikependon
#886 Added the necessary parameter property value setter attributes.
718ecaf
mikependon added a commit that referenced this issue Sep 13, 2021
@mikependon
Merge pull request #892 from mikependon/repodb-enhacements
fc85524 
#886 Added the necessary parameter property value setter attributes.
@mikependon mikependon added the fixed The bug, issue, incident has been fixed. label Sep 13, 2021
@mikependon
Copy link
Owner Author

This will be available on the next build > RepoDB v1.12.8-beta4.

mikependon added a commit that referenced this issue Sep 14, 2021
@mikependon
#886 Renamed the attributes and placing it to the proper namespaces.
fd730da
mikependon added a commit that referenced this issue Sep 14, 2021
@mikependon
#886 Integrated the PropertyValueSetter attributes into the compiler.
52fff15
mikependon added a commit that referenced this issue Sep 15, 2021
@mikependon
#886 Unit Tests for DbParameter and SqlParameter Attributes.
5202459
mikependon added a commit that referenced this issue Sep 15, 2021
@mikependon
#886 Added the IncludeInCompilation property on the PropertyValueAttr…
c322dad 
…ibute.
@mikependon mikependon reopened this Sep 15, 2021
mikependon added a commit that referenced this issue Sep 15, 2021
@mikependon
#886 Added the Unit Tests to the MySql, MySqlConnector and SqLite.
2944f7a
@mikependon mikependon added priority Top priority feature or things to do todo Things to be done in the future and removed fixed The bug, issue, incident has been fixed. labels Sep 15, 2021
@mikependon mikependon pinned this issue Sep 15, 2021
mikependon added a commit that referenced this issue Sep 16, 2021
@mikependon
#886 Added the Cachers, Mappers and Resolvers.
1e6c671
mikependon added a commit that referenced this issue Sep 17, 2021
@mikependon
#886 Added the mapping IntegrationTests via NameAttribute.
eaa82cb
mikependon added a commit that referenced this issue Sep 17, 2021
@mikependon
#886 More logic to support the PropertyValueAttribute retrieval and a…
923bfa9 
…lignment when being called to the actual operations.
mikependon added a commit that referenced this issue Sep 17, 2021
@mikependon
#886 Added the PropertyHandlerAttributes() method on the FluentMapper…
1ca1638 
… class.
mikependon added a commit that referenced this issue Sep 17, 2021
@mikependon
Merge pull request #909 from mikependon/repodb-enhancements
16bc277 
#886 Added the PropertyHandlerAttributes() method on the FluentMapper class.
@mikependon mikependon added deployed Feature or bug is deployed at the current release fixed The bug, issue, incident has been fixed. labels Sep 23, 2021
@mikependon
Copy link
Owner Author

This is now available on version RepoDB v1.12.8.

@mikependon mikependon unpinned this issue Sep 23, 2021
@xperiandri
Copy link
Contributor

xperiandri commented Jun 1, 2023 •
edited
Loading

@mikependon what is the purpose of DataTypeNameAttribute as it is never used?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mikependon mikependon

Labels
deployed Feature or bug is deployed at the current release enhancement New feature or request fixed The bug, issue, incident has been fixed. priority Top priority feature or things to do todo Things to be done in the future
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mikependon @xperiandri