Share via


SqlEntityConnection Type Provider (F#)

Provides the types to access a database, using a LINQ to Entities mapping. This type provider is useful when you are using the ADO.NET Entity Model for a database.

Namespace/Module Path: Microsoft.FSharp.Data.TypeProviders

Assembly: FSharp.Data.TypeProviders (in FSharp.Data.TypeProviders.dll)

type SqlEntityConnection<?ConnectionString : string,
                         ?ConnectionStringName : string
                         ?LocalSchemaFile : string,
                         ?Provider : string,
                         ?EntityContainer : string,
                         ?ConfigFile : string,
                         ?DataDirectory : string,
                         ?ResolutionFolder : string,
                         ?ForceUpdate : bool,
                         ?Pluralize : bool,
                         ?SuppressForeignKeyProperties : bool>

Static Type Parameters

Type Parameter

Description

?ConnectionString : string

The connection string for the database connection.

?ConnectionStringName : string

The name of the connection string for the database connection in the configuration file.

?LocalSchemaFile : string

The path to a .csdl file that contains the schema. This parameter is often used with ForceUpdate set to true.

?Provider : string

The name of the ADO.NET data provider to be used. The default is System.Data.SqlClient.

?EntityContainer : string

The name to use for the generated type that represents the container for the entities, also known as the data context. The default value is EntityContainer.

?ConfigFile : string

The name of the configuration file that’s used for connection strings. The default value is app.config or web.config.

?DataDirectory : string

The name of the data directory that replaces |DataDirectory| in connection strings. The default value is the project or script directory.

?Resolution Folder : string

A folder to be used to resolve relative file paths at compile time. The default value is the folder that contains the project or script.

?ForceUpdate : bool

Determines whether the type provider updates the generated types to reflect changes in the database schema. When ForceUpdate is false, the provider reacts to changes in the LocalSchemaFile. The default value is true.

?Pluralize : bool

If true, uses plural forms for the generated type names. The default value is false.

?SuppressForeignKeyProperties : bool

Exclude foreign key properties in entity type definitions. The default value is false.

Remarks

For a walkthrough that shows how to use this type provider, see Walkthrough: Accessing a SQL Database by Using Type Providers and Entities (F#).

The Entity Data Model Framework is a library for the .NET Framework that allows you to define a database schema largely independent of a specific data source (such as a SQL database). For more information, see ADO.NET Entity Framework and Entity Framework Overview. Database schemas that are represented by the Entity Data Model are encoded in a specific XML format in files with the .edmx extension.

The following table describes types generated by the SqlEntityConnection type provider for a declaration of the form:

type MyDb = SqlEntityConnection<parameters>

In the following table, EntityContainer is the single type generated by edmgen.exe, which has base type ObjectContext. This is the value of the static parameter EntityContainer, if it is given. Otherwise, it is the name chosen by edmgen.exe.

Type

Description

MyDb

The overall container type.

Contains a method GetDataContext that returns a simplified view of the data context. The method returns a new instance of MyDB.ServiceTypes.SimpleDataContextTypes.EntityContainer. The version with the connectionString parameter may be used when the connection string is determined at runtime.

MyDb.ServiceTypes

Contains the embedded full types and simplified types for the database.

MyDb.ServiceTypes.*

The embedded types generated by EdmGen.exe.

MyDb.ServiceTypes.EntityContainer

The data context type, inherited from ObjectContext.

MyDb.ServiceTypes.SimpleDataContextTypes.EntityContainer

Contains one method for each method of the full context type, including stored procedures and functions. The methods return ISingleResult<T>.

Contains one property for each property of the full context type. The properties return Table<TEntity>.

The property Connection gets the database connection as an instance of DbConnection.

The property DataContext gets the full data context, of type ObjectContext. This is the base type of the EntityContainer type generated by the type provider.

The Entity Data Model connection string that you specify at runtime when you call GetDataContext resembles the following:

metadata=res://*/entityNamespaceName.csdl|res://*/entityNamespaceName.ssdl|res://*/entityNamespaceName.msl;provider=provider;provider connection string="connectionString"

For more information about connection strings for the Entity Data Model, see Connection Strings

Platforms

Windows 8, Windows 7, Windows Server 2008 R2

Version Information

F# Core Library Versions

Supported in: 4.0

See Also

Tasks

Walkthrough: Accessing a SQL Database by Using Type Providers and Entities (F#)

Reference

Microsoft.FSharp.Data.TypeProviders Namespace (F#)

EdmxFile Type Provider (F#)

Other Resources

EDM Generator (EdmGen.exe)

Entity Framework Overview