If we create a table using openaccess, always the user is “dbo”.
if we create a table called “customer” then db will appear as dbo.customer
We need to separate the db table structure according the to the class library that we are using
“Authentication” class library there is a table called “Role_Type” and “Warehouse” class library there is a table called “Warehouse_Type”
In DB we need the table separation like.
How can we do this using openAccess.