Whenever I want to deploy I see this error message
Error 1 Type "SqlServerProject1.SecurityMode" is marked for native serialization, but field "_sm" of type "SqlServerProject1.SecurityMode" is of type "SqlServerProject1.SM", which is not marked with "LayoutKind.Sequential". Native serialization requires the type to be marked with "LayoutKind.Sequential". SqlServerProject1
In creating user define data types in SQL server 2005 , i have done all the things you have given in the procedure.
I have succeeded in building the application.
But when i tried the deploy option for deploying my application, i faced an error message which i have mentioned on the next line.
Error message :-
"Incorrect syntax near 'SqlServerProject1'"
"SqlServerProject1" is my project name.
So please help me to solve this problem.
waiting for your reply,
successful build, means a correct program structure and not successful deploy, means something wrong with data base
it's a general error
check that you enabled clr and make sure the connectionstring is correct
otherwise if your database supports clr and connectionstring is correct
i just cant't figure out the problem
I have similar problem while I try to deploy the assemby to my database. I can use SQL Server Management Studio to import the maganged dll but from within the Visual Studio I get the following error: The current database compatibility level does not support managed objects.
I did run the
EXEC sp_configure 'clr enabled', '1' reconfigure
on the database but even when I got it imported manually I could not see my new data type nor the stored procedures I created.