How would you design a solution to this problem?
unsure what would be the best approach -
I have a SQL table that stores SMS 3rd party providers.
Each provider support different protocols for its integration - (HTTP/SMPP).
According to the provider supported protocol it requires different parameters to be stored.
the HTTP providers stores -
1. URL endpoint
2. Api Key
The SMPP providers stores -
1. IpAddress
2. Port
3. Username
4. Password
Although they are different, they serve the same purpose therefore needs to exist in the same table.
So my question is, how would you handle this scenario both in the db and in the code?
Option 1 -
In the DB have a single table for
Protocol is an enum of HTTP/SMPP
And the Custom fields are nvarchar fields that are used according the the Protocol value.
I can select all the providers into a generic
Implement an
Have a factory method that receives a list of
Option2 -
Break the Provider table.
Leaving the Provider table only with the shared fields, and create a relationship tables for
And join both tables?
What would you do?
I have a SQL table that stores SMS 3rd party providers.
Each provider support different protocols for its integration - (HTTP/SMPP).
According to the provider supported protocol it requires different parameters to be stored.
the HTTP providers stores -
1. URL endpoint
2. Api Key
The SMPP providers stores -
1. IpAddress
2. Port
3. Username
4. Password
Although they are different, they serve the same purpose therefore needs to exist in the same table.
So my question is, how would you handle this scenario both in the db and in the code?
Option 1 -
In the DB have a single table for
ProviderProtocol is an enum of HTTP/SMPP
And the Custom fields are nvarchar fields that are used according the the Protocol value.
I can select all the providers into a generic
ProviderImplement an
IProviderProviderSMPPProviderHTTPHave a factory method that receives a list of
ProviderIProviderProtocolOption2 -
Break the Provider table.
Leaving the Provider table only with the shared fields, and create a relationship tables for
ProviderSMPPCredentialsProviderHTTPCredentialsAnd join both tables?
What would you do?
