Execute Dynamic SQL with sp_executesql
Sources: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver15
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Raw/Text Commands for Receipt Printer
Example: Test: https://webclientprint.azurewebsites.net/DemoPrintCommands.aspx https://jsprintmanager.azurewebsites.net/ Raw POS Command
Neodynamic Products
https://www.neodynamic.com/products/ JS Print Manager vs WebClientPrint https://www.neodynamic.com/products/printing/compare/ Product Cost JS Print Manager $49980 USD WebClientPrint $19980 USD JS Print Manager https://www.neodynamic.com/products/printing/js-print-manager/ WebClientPrint https://www.neodynamic.com/products/printing/raw-data/aspnet-mvc/
Neodynamic WebClientPrint Processor (WCPP)
WCPP Downloads https://www.neodynamic.com/downloads/wcpp/ WebClientPrint for ASP.NET Core, MVC & WebForms https://www.neodynamic.com/products/printing/raw-data/aspnet-mvc/ Test https://webclientprint.azurewebsites.net/DemoPrintCommands.aspx
Epson Receipt Printer
TM-T20II POS Receipt Printer https://epson.com/For-Work/Printers/POS/TM-T20II-POS-Receipt-Printer/p/C31CD52062 Epson’s cost-effective mPOS-friendly TM-T20II, designed for smaller retailers, is fast, reliable and supports all the leading mobile operating systems including iOS, Android and Windows. It features printing up to 200mm/second, high reliability, multiple ease-of-use features, dual interfaces and print options that reduce paper usage up to 30%.
Generate PDF using Syncfusion
Install Package Syncfusion.PDF.Net.Core Example Sources: https://help.syncfusion.com/file-formats/pdf/create-pdf-document-in-blazor
SQL Server Login Error: The certificate chain was issued by an authority that is not trusted
Are you trying to connect to a SQL Server instance and ending up with the error: The certificate chain was issued by an authority that is not trusted You aren’t alone. SQL Server 2005 introduced authentication encryption (by default) in the SQL Native Access Client (SNAC). SQL Server will self-generate a certificate that’s then used... » read more
Pass data from child to parent component in blazor
Child component to parent component communication The parent component assigns a callback method to the child component’s event. In Blazor, to expose an event we use EventCallback. Sources: https://www.pragimtech.com/blog/blazor/pass-data-from-child-to-parent-component-in-blazor/
Blazor Component: Pass value from child to parent
To pass values from a child to a parent component, see the following. Parent component Child component Sources: https://www.syncfusion.com/faq/blazor/components/how-do-you-pass-values-from-child-to-parent-using-eventcallback-in-blazor https://docs.microsoft.com/en-us/aspnet/core/blazor/components/data-binding?view=aspnetcore-5.0#child-to-parent-binding-with-chained-bind
AlwaysOn and Transaction Log
Availability Groups must retain all transaction log records until they have been distributed to all secondary replicas. Slow synchronization to even a single replica will prevent log truncation. If the log records cannot be truncated your log will likely begin to grow. This becomes a maintenance concern because you either need to continue to expand... » read more