Nemesis
Nemesis
PostsComments
CC#
Created by Nemesis on 3/19/2024 in #help
System.Data.SQLite command executions slower if a transaction is not explicitly passed
but not sure the reason behind such performance diff
10 replies
CC#
Created by Nemesis on 3/19/2024 in #help
System.Data.SQLite command executions slower if a transaction is not explicitly passed
As per SQLite doc, if no transaction is specified, an automatic is created which commits at the end of the command https://www.sqlite.org/lang_transaction.html
10 replies
CC#
Created by Nemesis on 3/19/2024 in #help
System.Data.SQLite command executions slower if a transaction is not explicitly passed
Is there any official doc page for System.Data.SQLite? I find it strange that such a widely used library doesn't have proper doc
10 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
thanks, will try that library out
24 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
no, it is an old project. migrating will be lot of work since theres lot of code
24 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
I have seen ClosedXML being recommended in many places
24 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
what are some recommended libraries for that?
24 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
.net framework 4.6.2 
 Excel.Application excelApp = excelReferenceInstance.GetExcelReference(); ;
                var excelWorkbook = excelApp.Workbooks.Open(Filename: localFilepath,
                                                            UpdateLinks: 0, // External reference (links) will not be updated when workbook is opened
                                                            ReadOnly: true,
                                                            Format: 5, // No delimiter because not opening a text file
                                                            Password: "",
                                                            WriteResPassword: "",
                                                            IgnoreReadOnlyRecommended: true,
                                                            Delimiter: null,
                                                            Editable: false,
                                                            Notify: false,
                                                            Converter: 0,
                                                            Local: true,
                                                            CorruptLoad: Excel.XlCorruptLoad.xlNormalLoad);
 Excel.Application excelApp = excelReferenceInstance.GetExcelReference(); ;
                var excelWorkbook = excelApp.Workbooks.Open(Filename: localFilepath,
                                                            UpdateLinks: 0, // External reference (links) will not be updated when workbook is opened
                                                            ReadOnly: true,
                                                            Format: 5, // No delimiter because not opening a text file
                                                            Password: "",
                                                            WriteResPassword: "",
                                                            IgnoreReadOnlyRecommended: true,
                                                            Delimiter: null,
                                                            Editable: false,
                                                            Notify: false,
                                                            Converter: 0,
                                                            Local: true,
                                                            CorruptLoad: Excel.XlCorruptLoad.xlNormalLoad);
24 replies
CC#
Created by Nemesis on 1/17/2024 in #help
✅ RPC not available on trying to read a Excel workbook using interop
yes, excel opens up fine in the machine
24 replies
CC#
Created by Nemesis on 4/5/2023 in #help
❔ Launch .NET MAUI application in admin mode
atlast found a video on that https://www.youtube.com/watch?v=XZuKJbUtXR8
3 replies
CC#
Created by Nemesis on 10/31/2022 in #help
Call to async method waiting for execution even without await
Are there any drawbacks of using Parallel.ForEach? That will create new thread for each function call right?
68 replies
CC#
Created by Nemesis on 10/31/2022 in #help
Call to async method waiting for execution even without await
ok, so my code wont execute the multiple Method calls in parallel? on changing Sleep to Thread.Delay, it is no longer waiting for the time, but it waits at the await Task.WhenAll
68 replies
CC#
Created by Nemesis on 10/31/2022 in #help
Call to async method waiting for execution even without await
oh, so sleep will block all the threads
68 replies
CC#
Created by Nemesis on 10/31/2022 in #help
Call to async method waiting for execution even without await
but shouldn't the sleep be executed in a separate thread?
68 replies