Entity Framework Code First data integration tutorials
Tutorials for using Entity Framework Code First with DynamoDB, Snowflake, Databricks, BigQuery and Dataverse through the CData ADO.NET provider.
What this integration does
Entity Framework is Microsoft's object-relational mapper. The code-first approach defines entities in code instead of generating them from a designer, which gives you more control when the source schema changes or when you want to decide exactly how entities behave.
How CData fits in
The CData ADO.NET Provider plugs into Entity Framework 6, so your entity classes and LINQ queries run against sources that are not SQL Server. The tutorials compare the approaches you can take, show how to tune queries, walk through moving an existing SQL Server application, and cover setup and securing access.
Entity Framework Code First tutorials by data source
Amazon DynamoDBEntity Framework on DynamoDB: Code First, Designer or ADO.NET?
Compare three ways to reach Amazon DynamoDB from .NET with the CData ADO.NET provider, then build the Entity Framework 6 Code First version step by step.
BigQueryBigQuery from Entity Framework 6: A Setup Checklist for .NET Devs
A checklist for getting an Entity Framework 6 Code First app to read Google BigQuery through the CData ADO.NET provider, from Google access to the first query.
DatabricksSwap SQL Server for Databricks in an Existing EF6 Code First App
Point an Entity Framework 6 Code First app at Databricks with the CData ADO.NET provider: what changes in App.config, the context and entities, and what stays.
Microsoft DataverseSecuring Entity Framework Access to Dataverse in a .NET App
Set up an Entity Framework 6 Code First app on Dataverse with the CData ADO.NET provider, covering identity choices, tenant scope, secrets and a minimal entity.
SnowflakeFaster EF6 Queries Against Snowflake: Warehouse, Scope, and LINQ
Tune an EF6 Code First app that reads Snowflake through the CData ADO.NET provider: scope the connection, shape LINQ queries and check the generated SQL.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.