Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

DTM Data Modeler serves as a CASE tool designed for database developers, facilitating both forward and reverse engineering processes. This user-friendly application allows for the manipulation of both logical and physical data models, visualized through entity-relationship diagrams. Aimed at database architects and developers, it connects seamlessly with data sources through the ODBC interface, ensuring compatibility with contemporary database management systems. In addition to managing fundamental model properties, such as entities and their interrelationships, the software enables the creation of indexes and triggers at the physical level that align with the modeled database tables. The feature for foreign key migration enhances schema development by providing a more intuitive and visual approach, while also minimizing the risk of integrity errors within the model. Furthermore, users can generate database schema objects directly in the database or produce SQL scripts that reflect the model and adhere to custom user-defined settings, making the entire process more efficient and streamlined. Overall, DTM Data Modeler equips developers with a robust set of tools for effective database design and management.

Description

Entity Framework (EF) Core is a versatile, lightweight, and open-source version of the widely used Entity Framework data access technology that operates across different platforms. It empowers .NET developers to interact with databases through .NET objects, significantly reducing the amount of data-access code that would typically need to be written. In EF Core, data interaction occurs through a model, which consists of entity classes and a context object that acts as a connection to the database. This context object facilitates both querying and data manipulation. Developers can generate a model directly from an existing database or manually create one to correspond with the database schema. After establishing a model, EF migrations can be employed to build a database from it, allowing for the database to evolve in tandem with any changes made to the model. Furthermore, instances of entity classes can be retrieved from the database using Language Integrated Query (LINQ), and operations such as creating, deleting, and modifying records in the database are accomplished through these instances, thus streamlining the data management process. Overall, EF Core simplifies database interactions and enhances the efficiency of data-driven applications.

API Access

Has API No 

API Access

Has API Yes 

Screenshots View All

Screenshots View All

Integrations

IBM Db2 Yes 
Oracle Database Yes 
SQL Server Yes 
.NET No 
ASP.NET No 
Azure Cosmos DB No 
Azure SQL Database No 
BigCommerce No 
C# No 
Firebird No 
Google Cloud Spanner No 
InterBase No 
Microsoft Dynamics 365 No 
MongoDB No 
MySQL No 
Progress OpenEdge No 
QuickBooks Online No 
Sugar Connect No 
VistaDB No 
Zoho CRM No 

Integrations

IBM Db2 Yes 
Oracle Database Yes 
SQL Server Yes 
.NET Yes 
ASP.NET Yes 
Azure Cosmos DB Yes 
Azure SQL Database Yes 
BigCommerce Yes 
C# Yes 
Firebird Yes 
Google Cloud Spanner Yes 
InterBase Yes 
Microsoft Dynamics 365 Yes 
MongoDB Yes 
MySQL Yes 
Progress OpenEdge Yes 
QuickBooks Online Yes 
Sugar Connect Yes 
VistaDB Yes 
Zoho CRM Yes 

Pricing Details

$75 per year
Free Trial Yes 
Free Version Yes 

Pricing Details

Free
Free Trial No 
Free Version Yes 

Deployment

Web-Based No 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac No 
Linux No 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) Yes 
In Person Yes 

Types of Training

Training Docs Yes 
Webinars Yes 
Live Training (Online) No 
In Person Yes 

Vendor Details

Company Name

DTM Data Modeler

Founded

1998

Country

Canada

Website

sqledit.com/dm/index.html

Vendor Details

Company Name

Microsoft

Founded

1975

Country

United States

Website

learn.microsoft.com/en-us/ef/core/

Product Features

Product Features

Database

Backup and Recovery No 
Creation / Development No 
Data Migration No 
Data Replication No 
Data Search No 
Data Security No 
Database Conversion No 
Mobile Access No 
Monitoring No 
NOSQL No 
Performance Analysis No 
Queries No 
Relational Interface No 
Virtualization No 

Alternatives

ERBuilder Reviews

ERBuilder

Softbuilder

Alternatives

ERBuilder Reviews

ERBuilder

Softbuilder