Must declare scalar variable @Id?

by

You need to actually pass in a parameter:

command.CommandText = "SELECT * FROM CUSTOMER WHERE Id = @Id;";
command.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
var reader = command.ExecuteReader();

More Related Contents:

  1. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  2. C# Sql Textbox Select
  3. How to execute a stored procedure within C# program
  4. How to get the connection String from a database
  5. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  6. Entity framework very slow to load for first time after every compilation
  7. How do I return multiple result sets with SqlCommand?
  8. Visual Studio: ContextSwitchDeadlock
  9. Query extremely slow in code but fast in SSMS
  10. How to connect to SQL server database from a Windows 10 UWP app
  11. ExecuteNonQuery for SELECT sql statement returning no rows
  12. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  13. SQLException : String or binary data would be truncated
  14. SSIS Task for inconsistent column count import?
  15. Entity-framework code is slow when using Include() many times
  16. Creating a SQL Server table from a C# datatable
  17. SQL: Update a row and returning a column value with 1 query
  18. Is there an Entity Framework 7 Database-First POCO Generator?
  19. Invalid column name sql error
  20. Retrieve image from database in asp.net
  21. Entity Framework | Sequence contains more than one matching element
  22. When is it better to store flags as a bitmask rather than using an associative table?
  23. Keyword Not Supported: Metadata
  24. Why is EF generating SQL queries with unnecessary null-checks?
  25. Know when to retry or fail when calling SQL Server from C#?
  26. What’s the best way to bulk database inserts from c#?
  27. How to insert data into SQL Server
  28. SQL Server Database Change Listener C#
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How do I connect to a SQL database from C#?

Leave a Comment