Devart Forums

I have a test code like this:
I am getting this exception in Linq Interactive window. Why? I don't get this exception when I run it in Visual Studio.

Message: The underlying provider failed on Open.
Type: System.Data.Entity.Core.EntityException
Source: EntityFramework
Site: Open
Stack Trace:
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at Devart.LinqInsight.Implementation.DataDump.AisQGNjHNq(IEnumerable )

There should be an inner exception. Specify its message and full stack trace.

This is a text message in the Linq interactive window. How do you view the inner exception in there?

The inner exception should be in the same window just after the error you have specified.

Additional question: is the Target framework of your project .NET Framework or .NET Core?

.NET Framework

So the inner exception was there. I just had to scroll down. It's trying to attach to an mdf file which not correct. It's supposed to be using a SQL Server instance.

When I click on Edit connection string, I get this dialog.


Five fields to enter and it's not clear what to enter. The help file has a totally different dialog which I can understand!
I entered a connection string in the data connection string and got an error that the password string is not supported.
What do I need to enter in the fields? Do you have an example?

Could you please send us a small test project so that we can reproduce the issue in our environment?

I am not sure if it's feasible to create one as our project is very big with libraries involved for database connection.

You didn't reply to my question for what to enter in the fields for the database dialog and that your documentation doesn't explain what to enter.

If a default constructor includes a connection string or there is a connection string with the same name as context name in app.config, LINQ Insight should pick up the connection string automatically.

You didn't reply to my question for what to enter in the fields for the database dialog and that your documentation doesn't explain what to enter.

For example, your app.config includes a valid connection string with the name MyConnString. In this case, fill the following field in the Edit Connection String window:
Name: MyConnString