Downloaded 24 times
More Related Content
Introduction to Telerik OpenAccess ORM
- 1. Introduction to TelerikOpenAccess ORMBy Peter Bahaa1
- 2. Bio!Technical Team Leadof DashSoftMSDN HDI PresenterTechnical Consultant for BeBrand.tvTechnical Consultant for LaserMarvelsCommunity Leader of dotnetwork.orgPastTechnical Team Lead of BeBrand.tv2
- 3. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking3
- 4. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking4
- 5. What is ORM?Object-relationalmapping (ORM, O/RM, and O/R mapping) "virtual object database" that can be used from within the programming language.5
- 6. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking6
- 7. Why Using ORM?Facilitatesimplementing the Domain Model pattern.Huge reduction in code.Changes to the object model are made in one place.Rich query capability.Navigation.Data loads are completely configurable.Concurrency support.Cache management.Transaction management and Isolation.Key Management.7
- 8. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking8
- 9. What is TelerikOpenAccess?Telerik OpenAccess is an Enterprise-grade .Net ORM that does the data access plumbing in desktop and web applications. Supporting both forward (model-first) and reverse (schema-first) mapping, The tool offers transparent persistence for your DAL and business objects. OpenAccess ORM provides tight Visual Studio integration and allows you to seamlessly create database independent code.9
- 10. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoFetch DemoDSW DemoORM Battle Benchmarking10
- 11. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support11
- 12. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support12
- 13. Visual Studio IntegrationSchema-FirstApproachModel-First ApproachPowerful WizardsRoundtrip Mapping13
- 14. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support14
- 15. Dynamic Data AccessQueryLanguagesLINQOQLSQLRuntime schema changesSchema Change API15
- 16. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase Support16
- 17. Performance and CachingFetchPlansLevel 2 Distributed CacheGeneric data access17
- 18. Performance and CachingFetchPlansLevel 2 Distributed CacheGeneric data access18
- 19. Fetch PlansFine-tune thefetching of the fields we are using from the database and not the whole object. Better performance.Less load on the database server.19
- 20.
- 21.
- 22. Performance and CachingFetchPlansLevel 2 Distributed CacheGeneric data access22
- 23. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support23
- 24. Supported Database FeaturesStoredProceduresViews24
- 25. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support25
- 26. Application Scenarios SupportDisconnectedAPIPartial TrustLazy LoadingAutomatic Change Tracking26
- 27. Application Scenarios SupportDisconnectedAPIPartial TrustLazy LoadingAutomatic Change Tracking27
- 28. Disconnected APIOpenAccess uniqueObjectContainer API concept has been the first ORM feature supporting disconnected data scenarios. The offline ObjectContainer API shares a common interface with the online ObjectScopeAPIThe ObjectContainer serves as a bag which can hold object network, provides serialization, change tracking and the ability to apply changes in a round-trip fashion to the database.28
- 29. Application Scenarios SupportDisconnectedAPIPartial TrustLazy LoadingAutomatic Change Tracking29
- 30. Partial TrustMost O/Rproducts do not support the partial trust paradigm out of the box. Most commonly the support was tied to severe limitations of the products functionality.Most popular products like Linq To Sql and Entity Framework had issues on their own with the partial trust support.30
- 31.
- 32. Application Scenarios SupportDisconnectedAPIPartial TrustLazy LoadingAutomatic Change Tracking32
- 33. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase Support33
- 34. IntegrationTelerik Reporting SQLAzureRIA ServicesAsp.Net and MVCSilverlight and Ado.Net Data Services34
- 35. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support35
- 36. Database SupportMicrosoft SQLServer 2005/2008 ExpressOracle Server 9.2, 10.x, 11.x Microsoft SQL Azure Advantage Database Server 8.1 SQL Anywhere Server 10.x Microsoft SQL Server 2000/2005/2008 and Compact 3.5Oracle Database 10g Express Edition Firebird Server 2.x MySQL 5.x 36
- 37. Features!Visual Studio IntegrationDynamicData AccessPerformance and cachingSupported Database FeaturesApplication Scenarios supportIntegrationDatabase SupportTechnical Support37
- 38. Technical SupportFree evenfor trial versionsConsulting more than a regular technical supportChoose the way that fits you:Support TicketsProduct DocumentationForumTelerik BlogsTelerik TVKnowledge baseCode LibraryWebinarsTelerik Trainer Product Resource Pages38
- 39. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking39
- 40.
- 41. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking41
- 42.
- 43. AgendaWhat is ORM?Whyusing ORM?What is Telerik OpenAccess ORM?Features!CRUD DemoDSW DemoORM Battle Benchmarking43
- 44. ORM Battle Benchmarking44PerformanceScorecardLINQ ScorecardSingle CRUD GraphMultiple CRUD GraphLINQ GraphQueries GraphPaging GraphFetch GraphMaterialization Graph
- 45.
- 46. Thank YouMy Blog:www.peterbahaa.netpeter@peterbahaa.net46