Visual studio winforms connection string on install
#Visual studio winforms connection string on install code#
XPO Profiler helps you find performance bottlenecks and code issues. Whenever a query passes the cache that has been executed previously, the result from that query is returned to the client immediately, without a roundtrip to the server. In addition, XPO caches queries and their results as they are being executed on the database server. After sending a request to a data source, UI control continues responding to user actions while data is being retrieved in a background thread.Įvery time a query to the database is made, XPO checks for new versions of the relevant objects in the database and updates the object cache when required. XPO can also load data asynchronously and therefore provide a fast and responsive UI even against very large datasets.
When Server Mode binding is used, data-aware operations are performed on the data server side and bound controls load data in small portions, on demand. With XPO, you can retrieve collections of persistent objects and bind them to WinForms, ASP.NET, WPF controls with ease. In addition, you can easily create OData services that expose data to any OData-compatible clients like DevExtreme or Xamarin mobile applications. You can publish data using Web Services, WCF and Remoting thus shielding direct database connections and reducing the amount of data that travels across the wire. XPO works great with complex distributed applications. The data model can be covered with lightweight unit tests because a memory data store can be used instead of a real database. You can host data in the cloud, since SQL Azure is fully supported. Should you decide to move your storage to a different database system, you'll only need to change the connection string. Whether using MS SQL Server, PostgreSQL, MySQL, Oracle, or others, you will use the same code to implement data access and management operations. XPO supports more than a dozen database management systems and implements a common high-level API. Target a Different Database Engine by Simply Changing the Connection String XPO not only provides an interface between the application's code and the database in the form of "insert-select-update-delete" queries to the database, but also enables features such as optimistic concurrency, inheritance mapping and deferred object deletion.
Unit of Work API encapsulates transactions into functional blocks that can be committed or rolled back altogether. Such a technique proves indispensable in scenarios when database structure is known only at runtime, so you can define persistent classes structure on the fly.īoth application-level and database-level transaction types can be manually managed using appropriate Session methods. This means that mapping information and custom attributes can be specified and modified dynamically.
NET Reflection, XPO supports abstract XML-based model for type metadata management. Object associations (one-to-one, one-to-many, many-to-many), aggregation and inheritance are all fully supported. NET Reflection and built-in attributes, XPO maps the properties of business objects to relational database tables. All you need is to define persistent object classes, and XPO will generate the appropriate database structure automatically. XPO is an Object-Relational Mapping (ORM) tool that handles all aspects of database creation and object persistence, allowing you to concentrate on your application's business logic.