Geeks With Blogs
Marcin Celej blog October 2006 Entries
Adding SqlCeParameter programmatically requires @ with the parameter name
I am developing Pocket PC application at the moment and I use SQL Server 2005 Everywhere inside. I encountered some difference to other ADO.NET providers. The difference is in adding SqlCeParameter programmatically to a SqlCeCommand. Here is the code I had:SqlCeCommand select = new SqlCeCommand("select Version from Customer where ID = @id", connection);select.Paramete... System.Data.SqlDbType.BigIn... = id;object result = select.ExecuteScalar(); You can see that in the query there is ......

Posted On Sunday, October 1, 2006 5:45 PM

Copyright © Marcin Celej | Powered by: