Open the same database with different users

RELATED TO:

Article information

Article relates to

 OpenAccess Classic

Created by

 Thomas, Telerik    

Last modified

 March 30, 2009

Last modified by

 Alexander, Telerik


HOW TO

Open the same database with different users.

SOLUTION

Here is a small code snippet how to open the same database with different users.

C#
// DatabaseHelper class to open the same database with different users.  
//  
// OpenAccess has a connection pool for all database connections.   
// If you specify the same connection id with different usernames we would have   
// to generate a new connection pool for this user, that is not possible yet.  
// To work around this issue you can specify different connection ids for   
// different users  
//  
// Note: OpenAccess now creates a connection pool for all users. You should   
// then reduce the amount of pooled connections to a smaller number!  
//  
// If you call this function with the same username you will get back the   
// same database object.  
class DatabaseHelper  
{  
internal static IObjectScope GetNewObjectScope(string username, string password)  
{  
string myconfig =  
     "<openaccess>" +  
     "<references>" +  
     // refer the DAL assembly with app.config with backendconfig section  
     "<reference assemblyname='db2users' />" +  
     "</references>" +  
     "<connections>" +  
     "<connection id=\"" + username + "Id\">" +  
     "<databasename>Database1</databasename>" +  
     "<servername>localhost</servername>" +  
    "<integratedSecurity>false</integratedSecurity>" +  
    // insert the right backendconfigurationname here  
    "<backendconfigurationname>mssqlConfiguration</backendconfigurationname>" +  
    "</connection>" +  
    "</connections>" +  
    "</openaccess>";  
    XmlDocument xmlDoc = new XmlDocument();  
    xmlDoc.LoadXml(myconfig);  
    return Database.Get(username + "Id", xmlDoc.DocumentElement).GetObjectScope(username,password);  
    }  
}  
 
class Program  
{  
  static void Main(string[] args)  
  {  
    IObjectScope scopeUser1 = DatabaseHelper.GetNewObjectScope("openaccess", "openaccess");  
    IObjectScope scopeUser2 = DatabaseHelper.GetNewObjectScope("telerik", "telerik");  
  }  
}  
 
 

VB.NET
' DatabaseHelper class to open the same database with different users.     
'     
' OpenAccess has a connection pool for all database connections.      
' If you specify the same connection id with different usernames we would have      
' to generate a new connection pool for this user, that is not possible yet.     
' To work around this issue you can specify different connection ids for      
' different users     
'     
' Note: OpenAccess now creates a connection pool for all users. You should      
' then reduce the amount of pooled connections to a smaller number!     
'     
' If you call this function with the same username you will get back the      
' same database object.     
Class DatabaseHelper  
    Friend Shared Function GetNewObjectScope(ByVal username As String, ByVal password As String) As IObjectScope  
            ' refer the DAL assembly with app.config with backendconfig section     
            ' insert the right backendconfigurationname here     
        Dim myconfig As String = "<openaccess>" + "<references>" + "<reference assemblyname='db2users' />" + "</references>" + "<connections>" + "<connection id=""" + username + "Id"">" + "<databasename>Database1</databasename>" + "<servername>localhost</servername>" + "<integratedSecurity>false</integratedSecurity>" + "<backendconfigurationname>mssqlConfiguration</backendconfigurationname>" + "</connection>" + "</connections>" + "</openaccess>" 
        Dim xmlDoc As New XmlDocument()  
        xmlDoc.LoadXml(myconfig)  
        Return Database.[Get](username + "Id", xmlDoc.DocumentElement).GetObjectScope(username, password)  
    End Function 
End Class 
 
Class Program  
    Shared Sub Main(ByVal args As String())  
        Dim scopeUser1 As IObjectScope = DatabaseHelper.GetNewObjectScope("openaccess", "openaccess")  
        Dim scopeUser2 As IObjectScope = DatabaseHelper.GetNewObjectScope("telerik", "telerik")  
    End Sub 
End Class 
 

Related Products
Data Access

Resources Buy Try

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community.

  • Videos

    Browse the Data Access videos to learn about handy features and tips and tricks.

  • Documentation

    Detailed help articles and API references for Telerik Data Access.

  • Knowledge Base

    Tutorials and working examples on how to achieve common scenarios.

  • Code Library

    Sample projects submitted by Telerik staff and community members.

  • Blog

    Stay up-to-date with the latest functionality, how-to articles, and industry trends.

  • Release History

    Up-to-date release notes for all new features and improvements.