Feature Request - CHECK constraint support

Feature Suggestions
1

Hey!

Yesterday I asked in this community how could I do a CHECK constraint in DBML, and @Phuc_Nguyen told me that wasn’t possible at the moment. He also said me that I could suggest it, so that’s why I’m here.

CHECK restrictions is something I use commonly, and when I create a database using DBLM, I have to convert the code to MySQL and write by myself the CHECK constraint. While that’s not a big problem, I think it would be really amazing if DBML could have support for it.

Thanks for reading this, and hope I suggested this correctly - it’s my first suggestion here!

2

Hi Tupiet,

What a great idea, I would love to see this feature as well as some others like “oneOf.”

All the best,
NIPE

3

Although I don’t use them often it would be good to be able to define CHCK constraints in DBML.

4

Hi,

Indeed the ability to import/export with CHECK constraint would be nice to have. We’ll consider supporting it soon and let you know when it’s available.

Thanks.

5

I second this, this would be great!

6

Hi, In the past year I’ve been using check constraints more in my databases. Can you let us know if support for them has been added to the DBML syntax roadmap?

Thanks

7

Hi Anthony,

Yes, support for CHECK constraints is on the roadmap. Given the high volume of requests, we’re considering prioritizing this feature and aim to implement it soon.

We appreciate your patience and enthusiasm.