Using .NET Objects
The ADO.NET Entity Framework data provider supports the .NET public objects, exposing them as sealed objects.
For more information, see .NET Objects Supported.
The ADO.NET Entity Framework programming contexts inherently eliminate the need to use some ADO.NET methods and properties. These properties and methods remain useful for standard ADO.NET applications. The online help, which is integrated into Visual Studio, describes the public methods and properties of each class.
Table 20 lists the properties and methods that are not required or are implemented differently when using the data provider with an ADO.NET Entity application.
 
Table 20
Properties and Methods Differences with the ADO.NET Entity Data Provider 
Property or Method
Behavior
PsqlCommand
AddRowID
Not supported. The ADO.NET Entity Framework does not process the additional data that is returned.
ArrayBindCount
Not supported. The application cannot influence this bind count on top of the ADO.NET Entity Framework.
ArrayBindStatus
Not supported. The application cannot influence this bind count on top of the ADO.NET Entity Framework.
BindByName
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
CommandTImeout
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
UpdatedRowSource
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
PsqlCommandBuilder
DeriveParameters
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
PsqlConnection
ConnectionTimeout
Supported only in a connection string.
StatisticsEnabled
Use the StatisticsEnabled or StatisticsDisabled stored procedure. See Using Stored Procedures with the ADO.NET Entity Framework for information on using this functionality in an ADO.NET Entity Framework application.
DataAdapter
UpdateBatchSize
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
Error
ErrorPosition
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
SQLState
Not supported. Instead, the data provider uses the ADO.NET Entity Framework programming contexts.
Creating a Model
The Entity Framework creates a model of your data in Visual Studio.
NOTE: Developing with the Microsoft ADO.NET Entity Framework data provider requires that you use Microsoft .NET Framework Version 4.5 or 4.6 and Visual Studio 2012 or later with version 4.2 of the PSQL ADO.NET Entity Framework data provider.
To create a model of your data in Visual Studio using the Entity Framework, you must first ensure that you already have the database schema available.
►
To use the Entity Framework for creating a model of your data in Visual Studio
1
Create a new .NET application, such as Windows Console, Windows Forms, in Visual Studio.
2
In the Solution Explorer, right-click the project and select Add > New Item.
3
Select ADO.NET Entity Data Model, then click Add.
4
The Entity Data Model Wizard appears. Based on whether you have configured Microsoft ADO.NET Entity Framework 6.0 (EF6), do one of the following:
•
If you have not configured EF6, select Generate from database and click Next.
•
If you have configured EF6, select EF Designer from database and click Next.
5
On the Choose your Data Connection page, click New Connection to create a new connection. If you have an established connection, you can select it from the drop-down list.
6
The Connection Properties window appears. Provide the necessary connection information and click OK.
7
The Wizard creates an Entity connection string.
a.
If the radio buttons are selectable, select Yes, include the sensitive data in the connection string to include the sensitive data in the connection string.
b.
In the Save entity connection settings field, type a name for the name of the main data access class or accept the default.
c.
Click Next.
8
Based on whether you have configured EF6, do one of the following:
•
If you have configured EF6 for the current project, proceed to the next step.
•
If you have not configured EF6 for the current project, on the Choose Your Version page, proceed with the default Entity Framework 5.0 by clicking Next.
NOTE: To use EF6 with your current project, exit the wizard, configure EF6, and then rebuild the project. When you rebuild the project after configuring EF6, the wizard does not display the Choose Your Version page and you can directly proceed to the next step.
9
Select the database objects that will be used in the model.
10
Click Finish. The model is generated and opened in the Model Browser.