help with mssql sqlserver gem, table prefix


i have a sqlserver database with multiple companies in there. the table “prefix” give you the company name:




how can i address the right company with AR / sqlserver gem?


The preferred solution would be to adjust the database schema so as to
fit the Rails Way. So have a companies table rather than multiple
tables with a prefix.


cant do that :frowning:

Honestly if you can’t conform to basics of what the ORM expects Rails is probably the wrong choice for you.

It sounds like you’re trying to write a Rails app against an already existing database (which, I presume, already has other clients connected to it and changing data in it). This sounds like a bad idea.