Open file with a specific connection

[mdf-ms2soft]

I'd like to open a specific file via powershell, and specify the connection as well. Is there a way to do this, it looks like I need to use -c, but its not well documented (that I can find). Right now, it looks like this: -S=myServer -D=myDB -E -c=???? -g 'myFile.sql'

[Charles-Gagnon]

azuredatastudio --help

The flags relevant to a connection are bolded below. -c is for executing a command (like from the command palette), that wouldn't normally be included if you just want to open a file and connect to a server.

Options
-d --diff Compare two files with each other.
-a --add Add folder(s) to the last active window.
-g --goto file:line[:character] Open a file at the path on the specified
line and character position.
-n --new-window Force to open a new window.
-r --reuse-window Force to open a file or folder in an
already opened window.
-w --wait Wait for the files to be closed before
returning.
--locale The locale to use (e.g. en-US or zh-TW).
--user-data-dir

Specifies the directory that user data is
kept in. Can be used to open multiple
distinct instances of Code.
-h --help Print usage.
-c --command Name of command to run
-D --database Database name
-S --server Server name
-U --user User name for server connection
--aad Use Azure Active Directory authentication
for server connection
-E --integrated Use Integrated authentication for server
connection

[MichaelAllenMiller]

What steps could I use to debug why these arguments are not working for me?

This is the command I'm running in powershell:
azuredatastudio --server SERVER_NAME --database DATABASE_NAME -E 'PATH_TO_FILE.sql';

It seems to connect to the server in the Connections list, but the connection is not set for the query/file/window.

[Charles-Gagnon]

Unfortunately, this just looks like a bug, I was able to repro it and looking at the code it does try to connect the editor, so something isn't right there. I filed an issue for us to track it: #18132

[MichaelAllenMiller]

Thank you!