LLBLGen Pro Support System General Chat feed https://www.llblgen.com/tinyforum//Forum/1 This is the RSS feed for the forum General Chat on the LLBLGen Pro Support System forum system. 30 en-us Version 5.5.4 to 5.10 by Otis <p>The documentation has all breaking changes: <a href="https://www.llblgen.com/Documentation/5.11/Designer/BreakingChanges.htm" rel="nofollow">https://www.llblgen.com/Documentation/5.11/Designer/BreakingChanges.htm</a> <a href="https://www.llblgen.com/Documentation/5.11/LLBLGen%20Pro%20RTF/migratingcode.htm" rel="nofollow">https://www.llblgen.com/Documentation/5.11/LLBLGen%20Pro%20RTF/migratingcode.htm</a></p> <p>(and please next time pick the right forum)</p> Otis https://www.llblgen.com/tinyforum/Thread/28820#153254 Fri, 12 Jan 2024 08:07:14 GMT Version 5.5.4 to 5.10 https://www.llblgen.com/tinyforum/Thread/28820#153254 Version 5.5.4 to 5.10 by oskarf <p>Hi</p> <p>Are there any breaking changes between version 5.5.4 and 5.10? Didn't find anything on the topic.</p> <p>Regards</p> oskarf https://www.llblgen.com/tinyforum/Thread/28820#153253 Thu, 11 Jan 2024 14:35:34 GMT Version 5.5.4 to 5.10 https://www.llblgen.com/tinyforum/Thread/28820#153253 FetchTypedList memory leak? by joshmag <blockquote><p class="quote-nickname">Otis wrote:</p> <p>One of the reasons we stopped supporting Sybase was indeed memory leaks in their ado.net providers (among other bugs), despite the fact we do call dispose on everything that exposes IDisposable... </p> <p>The typedlist is a datatable, so data fetched in the typedlist stays in memory till it goes out of scope. If you don't add event handlers to the typedlists's (datatable's) events (which might keep it in memory!) it should be a gc candidate once it's out of scope. </p> </blockquote> <p>Ok, thanks for letting me know that I don't have to explicitly clear anything.</p> joshmag https://www.llblgen.com/tinyforum/Thread/28711#152659 Mon, 29 May 2023 11:48:29 GMT FetchTypedList memory leak? https://www.llblgen.com/tinyforum/Thread/28711#152659 FetchTypedList memory leak? by Otis <p>One of the reasons we stopped supporting Sybase was indeed memory leaks in their ado.net providers (among other bugs), despite the fact we do call dispose on everything that exposes IDisposable... </p> <p>The typedlist is a datatable, so data fetched in the typedlist stays in memory till it goes out of scope. If you don't add event handlers to the typedlists's (datatable's) events (which might keep it in memory!) it should be a gc candidate once it's out of scope. </p> Otis https://www.llblgen.com/tinyforum/Thread/28711#152658 Mon, 29 May 2023 09:16:31 GMT FetchTypedList memory leak? https://www.llblgen.com/tinyforum/Thread/28711#152658 FetchTypedList memory leak? by joshmag <p>Hi,</p> <p>I am using the FetchTypedList function in the same way show in this document:</p> <p>https://www.llblgen.com/documentation/5.2/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/Adapter/Using%20TypedViews,%20TypedLists%20and%20Dynamic%20Lists/gencode_usingtypedlist_adapter.htm</p> <pre><code class="cs">OrderCustomerTypedList orderCustomer = new OrderCustomerTypedList(); using(DataAccessAdapter adapter = new DataAccessAdapter()) { PredicateExpression additionalFilter = new PredicateExpression(CustomerFields.Country == &quot;Brazil&quot;); ISortExpression sorter = new SortExpression(OrderFields.OrderId | SortOperator.Ascending); adapter.FetchTypedList(orderCustomer, additionalFilter, 0, sorter, false); } </code></pre> <p>However, I noticed that the data I fetch stay in memory forever (I verified this using vvmap). Am I supposed to clear the type list when I'm done? Is there some method I need to call to clean it up?</p> <p>BTW, I am using llblgen 5.2 with Sybase ASE.</p> <p>PS: Also, the data that is not being cleared is in the heap, not the managed heap. So maybe the leak, if there is one, is in the Sybase driver.</p> <p>Thanks</p> joshmag https://www.llblgen.com/tinyforum/Thread/28711#152656 Mon, 29 May 2023 08:50:59 GMT FetchTypedList memory leak? https://www.llblgen.com/tinyforum/Thread/28711#152656 Is it possible to update only specific fields in SQL server Database? by Otis <blockquote><p class="quote-nickname">martytheman wrote:</p> <p>Is it possible to use &quot;updatable views&quot;? In SQL Server management studio you can have a view that only contains a subset of the fields needed.</p> <p>A use case for this would be where you have<br /> - a product list with approx. 10 fields ( just a subset of all fields ) and update what you need - the full product if you are editing a single product that contains large fields that contain HTML / descriptive text that you don't need to load / update with every change of some fields with the list. </p> </blockquote> <p>You can save to a view (tho you have to switch the allowed actions on the mapping of the entity to create-retrieve-update-delete, otherwise it's seen as readonly. Updating a view might require you to write update triggers on the view tho, but that's up to you. </p> Otis https://www.llblgen.com/tinyforum/Thread/28704#152611 Mon, 08 May 2023 08:52:21 GMT Is it possible to update only specific fields in SQL server Database? https://www.llblgen.com/tinyforum/Thread/28704#152611 Is it possible to update only specific fields in SQL server Database? by Otis <blockquote><p class="quote-nickname">martytheman wrote:</p> <p>Hello</p> <p>I have a product table in SQL server that has some fields that are large and don't change often - is it possible to use the code to update only some fields in the database, only the modified fields for example?</p> <p>thanks Martin</p> </blockquote> <p>If you fetch an entity, and change only e.g. 2 fields, then an UPDATE query is generated that changes only those 2 fields. You can also decide not to fetch large fields by excluding them from the fetch, see e.g.: <a href="https://www.llblgen.com/Documentation/5.10/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/Adapter/gencode_excludedfields_adapter.htm" rel="nofollow">https://www.llblgen.com/Documentation/5.10/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/Adapter/gencode_excludedfields_adapter.htm</a></p> Otis https://www.llblgen.com/tinyforum/Thread/28704#152610 Mon, 08 May 2023 08:46:09 GMT Is it possible to update only specific fields in SQL server Database? https://www.llblgen.com/tinyforum/Thread/28704#152610 Is it possible to update only specific fields in SQL server Database? by martytheman <p>Is it possible to use &quot;updatable views&quot;? In SQL Server management studio you can have a view that only contains a subset of the fields needed.</p> <p>A use case for this would be where you have<br /> - a product list with approx. 10 fields ( just a subset of all fields ) and update what you need - the full product if you are editing a single product that contains large fields that contain HTML / descriptive text that you don't need to load / update with every change of some fields with the list. </p> martytheman https://www.llblgen.com/tinyforum/Thread/28704#152609 Sun, 07 May 2023 20:26:53 GMT Is it possible to update only specific fields in SQL server Database? https://www.llblgen.com/tinyforum/Thread/28704#152609 Is it possible to update only specific fields in SQL server Database? by martytheman <p>Hello</p> <p>I have a product table in SQL server that has some fields that are large and don't change often - is it possible to use the code to update only some fields in the database, only the modified fields for example?</p> <p>thanks Martin</p> martytheman https://www.llblgen.com/tinyforum/Thread/28704#152608 Sun, 07 May 2023 09:53:54 GMT Is it possible to update only specific fields in SQL server Database? https://www.llblgen.com/tinyforum/Thread/28704#152608 DatabaseSpecific by Otis <p>Hi, the folder name is used to place the generated code in, the project name is created using Project&lt;Suffix&gt; so you can specify the suffix for both dbgeneric and db specific (as well as the namespaces) in the <code>Project - Settings - LLBLGen Pro Runtime Framework - Template group specific, Adapter</code> indeed, the <code>Adapter db generic project file suffix</code> setting and the <code>Adapter db specific project file suffix</code> setting</p> Otis https://www.llblgen.com/tinyforum/Thread/28699#152592 Mon, 24 Apr 2023 16:31:23 GMT DatabaseSpecific https://www.llblgen.com/tinyforum/Thread/28699#152592