Where is the error in this SQL query?

Question

SQL

Hello!
I am writing an application in C#, and it uses the following query:

$"SELECT * FROM Автомобиль WHERE VIN_номер = '{VIN.Text}' AND Номер_заказа= '{Nomer_zakaza.Text}' AND Номер_филиала = '{Nomer_filiala.Text}'"

And this error pops up:

"Invalid object name 'Car'."

What can be done about it?

Answer 1

general, simple, how to understand it yourself:
string test = $" what I whine is fed
and look at the value of test with my eyes, or if it's not obvious, copy-paste the string into the sql console and get an error description from it.

Answer 2

It looks like the table name also needs to be enclosed in quotes.
https://stackoverflow.com/q/2901453/1828989 more information and examples here.