LLBLGen Pro Support System Bugs & Issues feed https://www.llblgen.com/tinyforum//Forum/10 This is the RSS feed for the forum Bugs & Issues on the LLBLGen Pro Support System forum system. 30 en-us NuGet packages - licenseUrl is deprecated by Otis <p>No, the license url in the nuget package is for a link to e.g. GPL, BSD2, MIT etc. We could have left it empty, but added a link to the website. It's not enforced. Our runtimes don't use license files, but are usable by people who have a valid license. </p> Otis https://www.llblgen.com/tinyforum/Thread/28853#153469 Fri, 22 Mar 2024 16:09:31 GMT NuGet packages - licenseUrl is deprecated https://www.llblgen.com/tinyforum/Thread/28853#153469 NuGet packages - licenseUrl is deprecated by mbp <p>Hi,</p> <p>We use tooling to check the licenses of our dependencies. We noticed that SD.LLBLGen.Pro NuGet packages are using licenseUrl and pointing to https://www.llblgen.com/Pages/buy.aspx</p> <p>However, licenseUrl is deprecated (see: https://learn.microsoft.com/en-us/nuget/reference/nuspec#license and https://github.com/NuGet/Announcements/issues/32)</p> <p>Instead, a license file should be included with the package.</p> mbp https://www.llblgen.com/tinyforum/Thread/28853#153466 Fri, 22 Mar 2024 10:02:12 GMT NuGet packages - licenseUrl is deprecated https://www.llblgen.com/tinyforum/Thread/28853#153466 Timeout using a TypedView in ASP.NET by Otis <p>I don't see what is wrong with our code, or that there is a bug at all. It's an aspect of authentication with an IIS application with sql server. </p> Otis https://www.llblgen.com/tinyforum/Thread/28852#153464 Fri, 22 Mar 2024 07:57:01 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153464 Timeout using a TypedView in ASP.NET by JayBee <blockquote><p class="quote-nickname">Otis wrote:</p> <blockquote><p class="quote-nickname">JayBee wrote:</p> <p>For several reasons we have decided to use multiple databases instead of using one big database. I started using master as the initial database so I could use that in all the different apps. Just convenience.</p> </blockquote> <p>Ok. Well, regardless, the query will use the catalogs that are used in your project, so the initial catalog specified is really just for the connection, you can specify one of the catalogs used in the project as well. But as I said, it's weird that it fails <em>in this particular case</em> and not in other queries in your site. </p> </blockquote> <p>For the time being I changed the string in the web.config. That is fine. When there is a solution to this specifc issue, I will happy to do some testing.</p> JayBee https://www.llblgen.com/tinyforum/Thread/28852#153462 Thu, 21 Mar 2024 14:25:42 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153462 Timeout using a TypedView in ASP.NET by Otis <blockquote><p class="quote-nickname">JayBee wrote:</p> <p>For several reasons we have decided to use multiple databases instead of using one big database. I started using master as the initial database so I could use that in all the different apps. Just convenience.</p> </blockquote> <p>Ok. Well, regardless, the query will use the catalogs that are used in your project, so the initial catalog specified is really just for the connection, you can specify one of the catalogs used in the project as well. But as I said, it's weird that it fails <em>in this particular case</em> and not in other queries in your site. </p> Otis https://www.llblgen.com/tinyforum/Thread/28852#153460 Thu, 21 Mar 2024 14:18:05 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153460 Timeout using a TypedView in ASP.NET by JayBee <p>For several reasons we have decided to use multiple databases instead of using one big database. I started using master as the initial database so I could use that in all the different apps. Just convenience.</p> JayBee https://www.llblgen.com/tinyforum/Thread/28852#153459 Thu, 21 Mar 2024 13:44:43 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153459 Timeout using a TypedView in ASP.NET by Otis <p>Strange! Especially as it only blocks on this query if I understood you correctly. </p> <p>Looking into it, the initial catalog is the database the connection makes its connection with, and master is a database that every user can access (readonly), iirc. <a href="https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder.initialcatalog?view=dotnet-plat-ext-8.0&amp;redirectedfrom=MSDN#System_Data_SqlClient_SqlConnectionStringBuilder_InitialCatalog" rel="nofollow">https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder.initialcatalog?view=dotnet-plat-ext-8.0&amp;redirectedfrom=MSDN#System_Data_SqlClient_SqlConnectionStringBuilder_InitialCatalog</a></p> Otis https://www.llblgen.com/tinyforum/Thread/28852#153457 Thu, 21 Mar 2024 13:06:40 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153457 Timeout using a TypedView in ASP.NET by JayBee <p>The website works when I change 'master' into another database name. I have changed it into a name that is different from the database where the stored procedure is in. Apparently using 'master' is the problem.</p> <p>After installing the visualizer and switching to VS 2019 I was able to have a look at the query executed when the error occurs. It ends with</p> <p>FROM [HITc_Logging].[dbo].[SBS_StortingLogPrcRcpt] WHERE ( [HITc_Logging].[dbo].[SBS_StortingLogPrcRcpt].[LogDateTimeCreated] BETWEEN @p1 AND @p2) ORDER BY [HITc_Logging].[dbo].[SBS_StortingLogPrcRcpt].[LogDateTimeCreated] ASC Parameter: @p1 : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 2024-02-01T00:00:00.0000000. Parameter: @p2 : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 2024-02-01T23:59:59.0000000.</p> <p>And this is what it should be.</p> JayBee https://www.llblgen.com/tinyforum/Thread/28852#153455 Thu, 21 Mar 2024 10:09:21 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153455 Timeout using a TypedView in ASP.NET by Otis <blockquote><p class="quote-nickname">JayBee wrote:</p> <p>The website functions normal. Other IO to the databases / tables involved works fine.</p> <p>When I copied the connection string the website is using to the config file of the console program, the console program also stops with the SQL Exception.</p> <p>Working: data source=SQL001\Meppel;initial catalog=XYZ;User ID=.....;Password=......;persist security info=False</p> <p>Not working: data source=SQL001\MEPPEL;initial catalog=master;User ID=......;Password=......;persist security info=False;packet size=4096</p> <p>When I changed master into XYZ the program run again.</p> <p>As far as I know LLBLGen does not use the catalog name but always the name of the database containing the tables or views involved. Isn't this true anymore?</p> </blockquote> <p>It generates the catalog name into the table references, correct, tho perhaps you're using catalog name overwriting? What's odd is that other queries work fine but this particular one doesn't... </p> <p>Could you enable tracing <a href="https://www.llblgen.com/Documentation/5.11/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_troubleshootingdebugging.htm#dynamic-query-engine-tracing" rel="nofollow">https://www.llblgen.com/Documentation/5.11/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_troubleshootingdebugging.htm#dynamic-query-engine-tracing</a> To see what the sql query looks like with this particular query and with a query that does work with the original connection string? </p> <p>The initial catalog is the catalog used when there's no catalog specified in the query, e.g. select * from dbo.customers. If you do select * from XYZ.dbo.customers, it will work with the not working connectionstring. </p> <p>For my understanding: the asp.net site works when you use the xyz connectionstring?</p> Otis https://www.llblgen.com/tinyforum/Thread/28852#153454 Thu, 21 Mar 2024 09:48:03 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153454 Timeout using a TypedView in ASP.NET by JayBee <p>The website functions normal. Other IO to the databases / tables involved works fine.</p> <p>When I copied the connection string the website is using to the config file of the console program, the console program also stops with the SQL Exception.</p> <p>Working: data source=SQL001\Meppel;initial catalog=XYZ;User ID=.....;Password=......;persist security info=False</p> <p>Not working: data source=SQL001\MEPPEL;initial catalog=master;User ID=......;Password=......;persist security info=False;packet size=4096</p> <p>When I changed master into XYZ the program run again.</p> <p>As far as I know LLBLGen does not use the catalog name but always the name of the database containing the tables or views involved. Isn't this true anymore?</p> JayBee https://www.llblgen.com/tinyforum/Thread/28852#153453 Thu, 21 Mar 2024 09:41:01 GMT Timeout using a TypedView in ASP.NET https://www.llblgen.com/tinyforum/Thread/28852#153453