Getting Started

• Overview
• My First Fiddle

Features

• Database Template
• File Access
• Header Directive
• MVC Project Type
• NuGet Package
• Fiddle Helper
• More

Community

• Collaborating
• Embedding
• Sharing
• Searching

Database Template

You can create a Fiddle that demonstrate SQL access by using some of our Database Templates.

Provider Supported:

• SQL Server
• SQL Compact

ORM Supported:

• Entity Framework Classic
• Entity Framework 6

Database Template Supported:

• Northwind Schema
• W3Schools Schema

Entity Framework Classic

The Z.EntityFramework.Classic NuGet Package must be added in the references.

Entity Framework 6

The EntityFramwork NuGet Package must be added in the references.

SQL Server

The System.Data.SqlClient assembly must be added in the references.

SQL Compact

The Microsoft.SqlServer.Compact NuGet Package must be added in the references.

ORM Examples

Add customers to an empty schema
View EF Classic Example
View EF6 Example

Northwind Examples

Select all products.
View EF Classic Example

Select all customers using Dapper.
View SQL Compact Example

W3Schools Examples

Update a customer.
View EF Classic Example

Insert and Select customers using the SQL Client and Dapper.
View SQL Server Example

Select all customers using Dapper.
View SQL Compact Example

Empty SQL Server Database Examples

Bulk Operation using SQL Server and EF Classic.
View EF Classic Example

Create a customer and insert it.
View SQL Server Example