dotConnect for DB2 is an enhanced ORM enabled data provider built on ADO.NET technology, that allows developers to easily integrate DB2 data with widely used data-oriented technologies and use them in .NET applications. dotConnect for DB2 supports DB2 for LUW 9.x and higher. dotConnect for DB2 can be used with Microsoft Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019 and Embarcadero Delphi Prism.
Key Features: Entity Framework Support. dotConnect for DB2 provides far more advanced Entity Framework support than IBM DB2 .NET Data Provider. It allows using code-first, model-first, database-first, and mixed development approaches, supports all versions of Entity Framework, and comes with a bundled visual ORM model designer - Entity Developer. Entity Developer allows much easier and more convenient Entity Framework model development, and features a number of tools and techniques to enrich the Entity Framework development capabilities. ASP.NET Projects Support. dotConnect for DB2 supports ASP.NET provider model, including the SimpleMembership provider, and offers DB2DataSource component for data access in ASP.NET projects. BIS Support. dotConnect for DB2 provides native Source and Destination components for data flows in SQL Server Integration Services packages and can be used in Analysis Services and Reporting Services projects. Powerful DataSet Tools. dotConnect for DB2 has DataSet wizard that greatly simplifies creating typed DataSets, powerful DataSet editor, and comprehensive DataSet manager, simplifying the creation of the corresponding data-bound controls. Monitoring. You can easily monitor all the database interaction via dotConnect for DB2 with the free dbMonitor tool that allows remote debugging, multiple process tracing, SQL parameter and error tracing. Support for ASP.NET Identity 1 and 2, Sync Framework. Entity Framework Core support. MS SQL Server 2016 is supported in SSIS DataFlow components. Visual Studio 2017 is supported.
