Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Collapse]DevExpress ORM Tool
  [Expand]Product Information
  [Expand]Getting Started
  [Expand]Fundamentals
  [Collapse]Feature Center
   [Expand]Data Representation
   [Expand]Object Relational Mapping
   [Expand]Connecting to a Data Store
   [Expand]Data Exchange and Manipulation
   [Expand]Querying a Data Store
   [Collapse]Using XPO in Web Applications
     Connecting XPO to a Database Server (ASP.NET)
     XpoDataSource
  [Expand]Concepts
  [Expand]Design-Time Features
  [Expand]Examples
  [Expand]Member Tables
 [Expand]DevExpress Data Library
 [Expand]Miscellaneous
 [Expand]API Reference
[Expand]Tools and Utilities
 End-User Documentation

Connecting XPO to a Database Server (ASP.NET)

To access a database server using XPO, a data access layer needs to be created and provided with connection settings. To accomplish this in an ASP.NET application, place the construction code into the Application_Start event handler in the Global.asax module of your Web Site. For information on how to add the Global.asax module to the Web Site, see Tutorial 6 - A Simple Guestbook (ASP.NET).

Note

When designing ASP.NET applications, using the ThreadSafeDataLayer object is recommended.

Handle the Web form's Page_Init event to create a session for the XpoDataSource component. The session must be linked to the Data Layer:

 

When designing multi-user ASP.NET applications based on XPO, it's recommended to create an XPO session for each request. Create a new session for each page, and dispose of it by overriding the Page.Render method.

Expanded See Also

Is this topic helpful?​​​​​​​