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.

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

Implement value conversions that spread out over multiple columns #31234

Open
Tracked by #31238 ...
AndriySvyryd opened this issue Jul 12, 2023 · 1 comment
Open
Tracked by #31238 ...

Comments

@AndriySvyryd
Copy link
Member

AndriySvyryd commented Jul 12, 2023

Multi-column value conversions were initially tracked by #13947 as a way to enable value objects, but we decided to instead implement them using complex types.

This issue tracks using value conversions as an alternative to complex types.

Pros

  • How properties decompose into columns is more flexible (e.g. two properties can be stored in one column or viceversa)

Cons

  • Opaque to queries (i.e. individual properties participating in a multi-column value conversion can't be used in conditions or projections)
@mguinness
Copy link

From linked issue:

Another area where this could be useful is storing DateTimeOffset into two fields for databases like MySQL which have no equivalent data type.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants