SqlAzManStorage.DBUsers "An item with the same key has already been added."

Topics: NetSqlAzMan Core, SQL Database Schema
Mar 30, 2014 at 11:47 AM
We're developing a multi-tenancy application and our NetSqlAzMan schema is directed to work with our users table (tblUser).
This table contains all the users in the system, therefore user name duplication is normal and differentiated by Application column.

While using the SqlAzManStorage, when first accessing the DBUsers attribute, a dictionary with user name as key and the user as value gets instantiated.
The DBUsers attribute is calling the GetDBUsers method which results in DB function call to netsqlazman_GetDBUsers with no parameters and we're receiving the whole tblUsers table.
An exception is being thrown ("An item with the same key has already been added.") because of the user name duplication in our table which uses as key in the DBUsers dictionary.