"PublicKeyToken <..> is not a valid extension type." Error?
.net, sql, vb.net, visual-studio
Solution
Seems to be a known problem of VisualStudio 2012. Restarting should help to remove these messages.
Problem
I added an UPDATE statement to my application which works fine. It updates the database correctly and other than the four error messages, I am seeing no problems. What does this mean? ``` Error 1 Type Microsoft.Data.Tools.Schema.Sql.Sql90DatabaseSchemaProvider, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a is not a valid extension type. 0 0 Error 2 Type Microsoft.Data.Tools.Schema.Sql.Sql100DatabaseSchemaProvider, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a is not a valid extension type. 0 0 Error 3 Type Microsoft.Data.Tools.Schema.Sql.Sql110DatabaseSchemaProvider, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a is not a valid extension type. 0 0 Error 4 Type Microsoft.Data.Tools.Schema.Sql.SqlAzureDatabaseSchemaProvider, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a is not a valid extension type. 0 0 ``` My code: ``` Using sqlCon = New SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\ITCSDatabase.mdf;Integrated Security=True") sqlCon.Open() Dim name As String = "Name" Dim link As String = "link" Dim dec As Integer = 0 Dim sqlUpdate = "INSERT INTO appTable " & _ "VALUES (41, @name, @link, 0, @dec, 0)" Dim updateCmd = New SqlCommand(sqlUpdate, sqlCon) updateCmd.Parameters.AddWithValue("@name", Name) updateCmd.Parameters.AddWithValue("@link", link) updateCmd.Parameters.AddWithValue("@dec", dec) updateCmd.ExecuteNonQuery() sqlCon.Close() End Using ``` *Note: it is a Local Database (.mdf) stored locally on the user's machine. **The local variables; name, link and dec are just for testing. Once it works correctly, they will be replaced by user input.