Support for LocalDB

[savornicesei]

Hi all,
I want to run database update scripts in azure pipeline, as part of the PR build. The easiest way was to target windows-latest and run the scripts on the LocalDB after starting the service with

sqllocaldb start mssqllocaldb

I'm using Invoke-DbaQuery and (localdb)\\MSSQLLocalDB for sql server instance but I get the following error

 Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]". Error: "Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter". Error: "Failed to parse instance name: (localdb)\\MSSQLLocalDB""
System.Management.Automation.ArgumentTransformationMetadataException: Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]". Error: "Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter". Error: "Failed to parse instance name: (localdb)\\MSSQLLocalDB""
 ---> System.Management.Automation.PSInvalidCastException: Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]". Error: "Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter". Error: "Failed to parse instance name: (localdb)\\MSSQLLocalDB""
 ---> System.Management.Automation.PSInvalidCastException: Cannot convert value "(localdb)\\MSSQLLocalDB" to type "Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter". Error: "Failed to parse instance name: (localdb)\\MSSQLLocalDB"
 ---> System.Management.Automation.PSArgumentException: Failed to parse instance name: (localdb)\\MSSQLLocalDB
   at Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter..ctor(String Name) in F:\Code\Github\dbatools\bin\projects\dbatools\dbatools\Parameter\DbaInstanceParameter.cs:line 462
   at lambda_method1007(Closure , Object )
   at System.Management.Automation.LanguagePrimitives.ConvertViaConstructor.Convert(Object valueToConvert, Type resultType, Boolean recursion, PSObject originalValueToConvert, IFormatProvider formatProvider, TypeTable backupTable)

I also noticed there is #8265 related to LocalDB - Am I right to assume LocalDB is unsupported by dbatools or I'm just calling it wrong?

Thank you.

[savornicesei]

I just tested with (localdb)\MSSQLLocalDB and it worked. yaaay!