How can I use a MySql User Defined Variable in a .NET MySqlCommand?

by

I found the solution in this blog

I have to add

;Allow User Variables=True

to the connection string:

$connectionstring = "Server=$Server;Port=$port;Database=$DataBase;Uid=$User;Pwd=$Password;allow zero datetime=yes;Allow User Variables=True"

works. I tested it with version 6.3.6.0. of MySql.Data.

More Related Contents:

  1. How can I run PowerShell with the .NET 4 runtime?
  2. File / folder chooser dialog from a Windows batch script
  3. Powershell v3 Invoke-WebRequest HTTPS error
  4. Using .NET objects within a Powershell (V5) class
  5. How do I add a reference to the MySQL connector for .NET?
  6. Deep copying a PSObject
  7. How can I check if a string is null or empty in PowerShell?
  8. Unable to convert MySQL date/time value to System.DateTime
  9. PowerShell script to return versions of .NET Framework on a machine?
  10. How to create System.IO.StreamWriter with Encoding in Powershell?
  11. How to insert a very large number of records into a MySql database as fast as possible
  12. PowerShell generic collections
  13. How to check an exchange mailbox via powershell?
  14. Determine if windows is currently playing sound
  15. What’s the best way to automate secure FTP in PowerShell?
  16. Powershell Calling .NET Assembly that uses App.config
  17. What do you call these? [array][string][int]
  18. Powershell Unload Module… completely
  19. Binding ItemsSource of a ComboBoxColumn in WPF DataGrid
  20. store image in database or in a system file? [closed]
  21. How to serialize an object to XML without getting xmlns=”…”?
  22. Difference between web reference and service reference?
  23. How did Microsoft create assemblies that have circular references?
  24. How to modify .NET config files during installation?
  25. Why doesn’t ClickOnce in Visual Studio deploy content files from dependent assemblies?
  26. How to print datagridview table with its header in vb.net?
  27. Enum is Reference Type or Value Type?
  28. How to package a portable .NET library targeting .NET Core?
  29. Is it safe to call an RCW from a finalizer?
  30. Can we get the UAC prompt to show only once?

Leave a Comment