On 2017-01-01 04:24, Adam Wilson wrote:
My idea: Each data store has it's own implementation with it's own naming convention. For example (ADO.NET): - SqlConnection (MSSQL) - NpgsqlConnection (Npgsql)Yes, this means that you have to change names in your code if you switch data-stores, but since you are already changing your queries, which is a much more difficult change, this isn't a significant additional cost.
I don't think we should try to make implementations different just because. If you have an SQL builder or an ORM on top of the interface that abstract the differences in the SQL syntax, it's possible to switch driver, within reason.
-- /Jacob Carlborg
