Devart Forums

LucidCoder

I am not sure if it will help you but this is what I use in my connection string:

Default Command Timeout = 0

LucidCoder

Hello;

I have verified that I get the same error when using a standard azure data connector and when usings a postgresql dotconnect.

I am using the beta version in VS 2015

The below will return 1200 records in Linq Insight, it is hitting a azure Sql database:

Code: Select all

var test = (from t in aDb.rep_info select t).ToArray();

But this will generate a error in Linq Insight, even through it will run correctly:

Code: Select all

var test = (from t in aDb.rep_info select  new {t.first_name}).ToArray();

Message: One or more errors occurred.
Type: System.AggregateException
Source: mscorlib
Site: ThrowIfExceptional
Stack Trace:
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at Devart.LinqInsight.Roslyn.RoslynQueryExecutor.PrepareInternal(SourceCodeInfo sourceCode, CancellationToken token, String privateBinPath)
at Devart.LinqInsight.Implementation.QueryExecutor.Prepare()
at Devart.LinqInsight.Implementation.QueryExecutor.Execute()
at Devart.LinqInsight.Implementation.QueryExecutor.<>c__DisplayClass59_0.<StartNewTask>b__0()
Inner Exception:
Message: Object reference not set to an instance of an object.
Type: System.NullReferenceException
Source: Microsoft.CodeAnalysis.CSharp.Workspaces
Site: SomeParentHasMissingCloseBrace
Stack Trace:
at Microsoft.CodeAnalysis.CSharp.Formatting.BaseFormattingRule.SomeParentHasMissingCloseBrace(SyntaxNode node)
at Microsoft.CodeAnalysis.CSharp.Formatting.BaseFormattingRule.AddBraceSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken)
at Microsoft.CodeAnalysis.CSharp.Formatting.SuppressFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.Formatting.Rules.AbstractFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.Formatting.Rules.AbstractFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.Formatting.Rules.AbstractFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.CSharp.Formatting.ElasticTriviaFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.Formatting.Rules.AbstractFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.Formatting.Rules.AbstractFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.CSharp.Formatting.SpacingFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.Rules.NextAction`1.Invoke(List`1 arguments)
at Microsoft.CodeAnalysis.CSharp.Formatting.WrappingFormattingRule.AddSuppressOperations(List`1 list, SyntaxNode node, SyntaxToken lastToken, OptionSet optionSet, NextAction`1 nextOperation)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.<.ctor>b__8_0(Int32 index, List`1 list, SyntaxNode node, SyntaxToken lastToken, NextAction`1 next)
at Microsoft.CodeAnalysis.Formatting.ChainedFormattingRules.AddContinuedOperations[TArg1](Int32 index, List`1 arg1, SyntaxNode node, SyntaxToken lastToken, IActionHolder`1 actionCache)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.<CreateNodeOperationTasks>b__16_4(List`1 l, SyntaxNode n)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.<>c__DisplayClass17_1`1.<AddOperations>b__2(SyntaxNode n)
at Microsoft.CodeAnalysis.Formatting.TaskExecutor.SynchronousExecutor.ForEach[T](IEnumerable`1 source, Action`1 action, CancellationToken cancellationToken)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.AddOperations[T](List`1 nodes, Action`2 addOperations, CancellationToken cancellationToken)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.<>c__DisplayClass16_0.<CreateNodeOperationTasks>b__3(Task`1 task)
at Microsoft.CodeAnalysis.Formatting.TaskExecutor.SynchronousExecutor.ContinueWith[T1,T2](Task`1 previousTask, Func`2 nextAction, CancellationToken cancellationToken)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.CreateNodeOperationTasks(CancellationToken cancellationToken)
at Microsoft.CodeAnalysis.Formatting.AbstractFormatEngine.<FormatAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.CodeAnalysis.Formatting.AbstractSyntaxFormattingService.<FormatIndividuallyAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.CodeAnalysis.Formatting.AbstractSyntaxFormattingService.<FormatAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.CodeAnalysis.Formatting.Formatter.<FormatAsync>d__21.MoveNext()

LucidCoder

I'm sorry...I am not sure how to do that.

The database referenced is large and read only from my end - I did not create it and only have read access to it.

I can provide you the entire project as a zip file, will that include the DDL/DML script?

Joe

LucidCoder

The entire code is above, I can send you that in a project...but you will not be able to login or run queries against the customers database unless they whitelist your IP.

Will sending you the entire project actually help?

I provided a pretty clear example - a linq query that takes minutes to run and a ADO query that runs in a second or two along with all the logs.

Please let me know next steps...I will continue this through email then post the final solution here so as to not keep muddying up this chain.

Joe

LucidCoder

I have two trouble tickets open on this issue because I was not able to figure out how to update them.
I opened a second after not hearing anything on the first - can you track a trouble ticket?.

I spent a full day trying various things with no results.

I am currently switched back to npgsql along with Dapper for a solution until I can get this resolved.

Here is a update - one piece of code, two different ways of accessing the data - one returns results in about a second the second takes from 100 seconds to never returning at all:

Code: Select all

           var dateToCheck = new DateTime(2017, 2, 22);
            //The below string is as close to recreating the problem Linq query as I know how to do
            string mySelectQuery = "select distribution_stop_information.unique_id_no, stop_name, stop_address, route_code, customer_reference,"+
                "distribution_line_items.datetime_created, rma_number from distribution_stop_information join distribution_line_items on " +
                "distribution_line_items.unique_id_no = distribution_stop_information.unique_id_no " +
                "where distribution_line_items.datetime_created > '2/22/2017' and customer_no = '91000'";

            PgSqlConnection pgConnection = new PgSqlConnection(myConnection);
            PgSqlCommand pgCommand = new PgSqlCommand(mySelectQuery, pgConnection);
            pgConnection.Open();
            PgSqlDataReader pgReader = pgCommand.ExecuteReader();

            //steps through it just to verify that the data is in fact coming back
            try
            {
                int counter = 0;
                while (pgReader.Read())
                {
                    counter++;
                    Console.WriteLine(counter.ToString() + " " + pgReader.GetString(0));
                }
            }
            finally
            {
                // always call Close when done reading.
                pgReader.Close();
                // always call Close when done reading.
                pgConnection.Close();
            }


            var Stops = (from stops in rDb.DistributionStopInformations
                         join line in rDb.DistributionLineItems on stops.UniqueIdNo equals line.UniqueIdNo
                         where line.DatetimeCreated > dateToCheck && stops.CustomerNo == TNGCustNo
                         select new
                         {
                             stops.UniqueIdNo,
                             stops.StopName,
                             stops.StopAddress,
                             stops.RouteCode,
                             stops.CustomerReference,
                             line.DatetimeCreated,
                             line.RmaNumber
                         }
                 ).ToArray();

LucidCoder

This just does not seem right.

I own a standard copy of LInq Insight, but it will not work with VS 2015 (even though 2017 is up to a RC).

I cannot test the beta to see if it works because when I install it I am told that my trial period is over and the results feature is disabled.

I really do not mind paying for the upgrade to get it to work, but I would at least like to know if it actually does work first. It has been in beta for 17 months now...are you no longer actively developing this tool?

Joe

LucidCoder

Hello;

I am getting extremely slow performance using the below query:

Code: Select all

             var Stops = (from stops in rDb.DistributionStopInformations
                             join line in rDb.DistributionLineItems on stops.UniqueIdNo equals line.UniqueIdNo
                         where line.DatetimeCreated > dateToCheck && stops.CustomerNo == TNGCustNo
                         select new
                         {
                             stops.UniqueIdNo,
                             stops.StopName,
                             stops.StopAddress,
                             stops.RouteCode,
                             stops.CustomerReference,
                             stops.RmaUniqueId,
                             line.RmaNumber
                             }
                         ).ToArray();

The above takes over two minutes and often times out.
I can run the same query using pgAdminII in just a few seconds.

From dbMonitor:

Code: Select all

SELECT t1.unique_id_no, t1.route_code, t1.customer_reference, t1.stop_name, t1.stop_address, t1.rma_unique_id, t2.rma_number
FROM cops_reporting.distribution_stop_information t1
INNER JOIN cops_reporting.distribution_line_items t2 ON t1.unique_id_no = t2.unique_id_no
WHERE (t2.datetime_created > :p0) AND (t1.customer_no = :p1)

I can run the following in just a couple seconds:

Code: Select all

            string mySelectQuery = "select distribution_line_items.item_sequence_no, distribution_stop_information.stop_name, distribution_stop_information.stop_address, distribution_stop_information.route_code, distribution_line_items.item_number," +
                "distribution_stop_information.unique_id_no,distribution_line_items.rma_original_unique_id, distribution_line_items.rma_number from distribution_line_items join distribution_stop_information on " +
                "distribution_line_items.unique_id_no = distribution_stop_information.unique_id_no where distribution_line_items.datetime_created > '2/21/2017' and distribution_stop_information.customer_no = '91000'";
             
            PgSqlConnection pgConnection = new PgSqlConnection(myConnection);
            PgSqlCommand pgCommand = new PgSqlCommand(mySelectQuery, pgConnection);
            pgConnection.Open();
            PgSqlDataReader pgReader = pgCommand.ExecuteReader();
            
            try
            {
            int counter = 0;
                while (pgReader.Read())
                {
                    counter++;
                    Console.WriteLine(counter.ToString() + " " + pgReader.GetString(0));
                }
            }
            finally
            {
                // always call Close when done reading.
                pgReader.Close();
                // always call Close when done reading.
                pgConnection.Close();
            }

But I have no worked with this type of data before -- if I can't speed up linq, how can I return the data using the pgReader in a way I can use linq queries against (strongly typed)?

Joe

LucidCoder

Hello;

Is this possible or is it a planned for future feature?
This would be so helpful for me at least!

Thank you

Joe

LucidCoder

I purchased the product, did a uninstall and a reinstall and everything is working correctly as far as this issue is concerned.

Thank you

LucidCoder

It does it on every project.
Visual studio 2013
Version 4.5.51641
well...here:
Microsoft Visual Studio Professional 2013
Version 12.0.31101.00 Update 4
Microsoft .NET Framework
Version 4.5.51641

Installed Version: Professional

LightSwitch for Visual Studio 2013 06177-004-0444002-02794
Microsoft LightSwitch for Visual Studio 2013

Team Explorer for Visual Studio 2013 06177-004-0444002-02794
Microsoft Team Explorer for Visual Studio 2013

Visual Basic 2013 06177-004-0444002-02794
Microsoft Visual Basic 2013

Visual C# 2013 06177-004-0444002-02794
Microsoft Visual C# 2013

Visual C++ 2013 06177-004-0444002-02794
Microsoft Visual C++ 2013

Visual F# 2013 06177-004-0444002-02794
Microsoft Visual F# 2013

Visual Studio 2013 Code Analysis Spell Checker 06177-004-0444002-02794
Microsoft® Visual Studio® 2013 Code Analysis Spell Checker

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.

Windows Phone SDK 8.0 - ENU 06177-004-0444002-02794
Windows Phone SDK 8.0 - ENU

ASP.NET and Web Tools 12.4.51016.0
Microsoft Web Developer Tools contains the following components:
Support for creating and opening ASP.NET web projects
Browser Link: A communication channel between Visual Studio and browsers
Editor extensions for HTML, CSS, and JavaScript
Page Inspector: Inspection tool for ASP.NET web projects
Scaffolding: A framework for building and running code generators
Server Explorer extensions for Microsoft Azure Websites
Web publishing: Extensions for publishing ASP.NET web projects to hosting providers, on-premises servers, or Microsoft Azure

ASP.NET Web Frameworks and Tools 2012.2 4.1.21001.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.21010.0
For additional information, visit http://www.asp.net/

AutoHistory 1.0
Information about my package

Common Azure Tools 1.3
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Devart dotConnect for PostgreSQL 7.3.313.0
Devart dotConnect for PostgreSQL
Copyright 2002 - 2014 Devart. All rights reserved.
Web: www.devart.com/dotconnect/postgresql
Support: [email protected]

Devart Entity Developer 5.7.510.0
Devart Entity Developer
Copyright © 2008-2014 Devart. All rights reserved.
Web: www.devart.com/entitydeveloper
Support: [email protected]

Devart LINQ Insight Express 3.2.610.0
Devart LINQ Insight Express
Copyright © Devart 2012-2014. All rights reserved.
Web: www.devart.com/linqinsight
Support: [email protected]

Microsoft Azure HDInsight HQL Service 1.0.0000.0
Language service for Hive query

Microsoft Azure HDInsight Tools for Visual Studio 1.0.0000.0
An integrated development environment for HDInsight application development.

Microsoft Azure Mobile Services Tools 1.3
Microsoft Azure Mobile Services Tools

Microsoft Azure Tools 2.5
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.5.21104.1601

NuGet Package Manager 2.8.50926.663
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Office Developer Tools for Visual Studio 2013 ENU 12.0.30626
Microsoft Office Developer Tools for Visual Studio 2013 ENU

PowerShell Tools 1.3
Provides file classification services using PowerShell

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Data Tools 12.0.41012.0
Microsoft SQL Server Data Tools

Telerik Data Access 2014.3.1027.1
Telerik Data Access Copyright © 1996–2014 Telerik AD
Telerik Data Access is the ultimate data access layer solution for Microsoft .NET database applications.
www.telerik.com/orm

Telerik Reporting
For more information please visit http://www.telerik.com/reporting. Copyright © 2005–2015 Telerik AD

Telerik WinForms VSExtensions 2014.6.1128.0
Telerik UI for WinForms VSExtensions

Windows Phone 8.1 SDK Integration 1.0
This package integrates the tools for the Windows Phone 8.1 SDK into the menus and controls of Visual Studio.

Workflow Manager Tools 1.0 1.0
This package contains the necessary Visual Studio integration components for Workflow Manager.

LucidCoder

Hello;

Not sure if I am doing something wrong, I did search the forum first.

The following Linq produces results but nothing in the SQL. I am using the trial with 30 days left:

Code: Select all


from stops in context.DistributionStopInformations
join items in context.DistributionLineItems on stops.UniqueIdNo equals items.UniqueIdNo
where stops.CustomerNo == (decimal?)97808m && DbFunctions.TruncateTime(stops.DatetimeCreated) == (DateTime?)DateToCheck1.Date
select new {
	createdDate = stops.DatetimeCreated,
	stopName = stops.StopName,
	uniqueID = stops.UniqueIdNo,
	item = items.ItemNumber
}

Thank you!

Devart Forums

Search found 11 matches

Re: Server did not respond within the specified timeout interval

getting an error on select new

Re: Extremely slow performance

Re: Extremely slow performance

Re: Extremely slow performance

Re: VS2015

Extremely slow performance

export result grid to excel or copy to clipboard

Re: no SQL showing

Re: no SQL showing

no SQL showing