Ok, I thought that post would help but I’m not sure it has. From the above post I understand that using a single schema with multiple connections, then choosing a connection from the client is not possible.
However, I’m confused as to what the best suggestion is. Initially there will be about 100 restaurants connected to this server, I hope I do not have to have 100 of each table in the database, all with a different connection set in the Table.Statements? This would not work for us as the DB has about 30 tables. I hope there’s a more suitable way to do this.
Thanks,
Graham