how to open EntityConnection without connection string

Question

I need to open the connection for Entity Framework without a connection string.

Due to a security layer that we are using I'm, we don't allow to connect to SQL Server using connection string, So we have a DLL that returns an opened SqlConnection.

EF version: 6.2.0

Error:

MetadataWorkspace must have EdmItemCollection pre-registered.

I tried to give the entityConnection as SqlConnection but I get an error.

Sample code:

Public Shared Function getEntityConnection() As EntityConnection
      Dim workspace As New MetadataWorkspace()
      Return New EntityClient.EntityConnection(workspace, AppCommon.AppFunctions.AppGetSQLCon(True))
End Function

AppCommon.AppFunctions.AppGetSQLCon(True) is the function which returns the SqlConnection instance.

But it's not working, does anyone have a solution for this issue?

Please supply: EF version, which exception, and indicate at which line of code the exception is thrown. — Gert Arnold
– Gert Arnold, Commented Jan 2, 2020 at 9:53
Since this is all your own custom code and nothing standard, it's extremely difficult to really help you with anything ..... — marc_s
– marc_s, Commented Jan 2, 2020 at 10:03
I'm just looking for a solution to open the EF connection without a connection string. — Basil A.
– Basil A., Commented Jan 2, 2020 at 10:04
Have you read this question? I would hope so, given that it was the second result when I searched the web for your error message. — jmcilhinney
– jmcilhinney, Commented Jan 2, 2020 at 11:00

Basil A. · Accepted Answer · 2020-01-06 09:12:24Z

0

Finally I found the solution for connecting the entityframework without a connection string, So what you need to is the following:

change the constructor of the entity `DbContext' to recive the connection from a function like this:

    Public Sub New()
        MyBase.New(getEntityConnection(), False)
    End Sub

Then inside that function return an entity-connection object from an open sqlconnection obbject as the following:

Public Shared Function getEntityConnection() As EntityConnection
    Dim workspace As New MetadataWorkspace(New String() {"res://*/"}, New Assembly() {Assembly.GetExecutingAssembly()})
    Return New EntityClient.EntityConnection(workspace, getSqlConnectionObject())        
End Function

Now your entityframework is connected to the database without a connection string

answered Jan 6, 2020 at 9:12

Basil A.

1,65112 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to open EntityConnection without connection string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related