Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

Question

0.00/5 (No votes)

See more:

Hi Guys,

i have created a wcf service, which interacts with sql server using Microsoft.Sqlserver.smo. the main task of this service os to create a database from a script. while accessing the smo object for executenonquery it's throwing "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information." error.

i tried over internet and googled, everyone said by adding certain tag in app config it will resolve the issue. But it didn't. the tag is as fallows:

XML

<startup uselegacyv2runtimeactivationpolicy="true">
    <supportedruntime version="v4.0" sku=".NETFramework,Version=v4.0" /> 
    <requiredruntime version="v4.0" />
</startup>

still i am getting the same exception while accessing sqlserver.smo object. please provide me the solution.

i want to submit my code, but i didn't find any attachment option here. if any one is having solution for this please send me their mail id, i will send the code.

Posted 16-Jan-14 18:09pm

ChaitanyaPottam

Updated 16-Jan-14 18:12pm

Ron Beyer

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Answer 1 · 2014-01-16T18:19:00

Solution 1

See: http://msdn.microsoft.com/en-us/library/aa374182(v=vs.85).aspx[^]

Especially the note:

Quote:
Names of elements and attributes are case-sensitive. The values of elements and attributes are all case-insensitive, except for the value of the type attribute.

So, uselegacyv2runtimeactivationpolicy should actually be useLegacyV2RuntimeActivationPolicy. supportedruntime should be supportedRuntime and you should not be using the requiredRuntime element in v4.0 applications.

Posted 16-Jan-14 18:19pm

Ron Beyer

Updated 16-Jan-14 18:20pm

v2

Comments

ChaitanyaPottam 17-Jan-14 0:23am

Hi Ron as u specified i have done the modifications still it's throwing me the same exception. if you want i can send you the code, so that u can reach to exact point of discussion where i got struck. suggest me how could i send you my code.

Ron Beyer 17-Jan-14 0:28am

After a little more research it seems that SMO is not available for .NET 4, even though Microsoft says the above will work, people are saying it doesn't. Looks like the only reliable fix is to downgrade your application to use 3.5. You can use PasteBin to paste your code, what are you needing SMO for?

Ron Beyer 17-Jan-14 0:33am

If you are just running a simple database creation script, have you tried using the ADO.NET classes (SQLConnection, SQLCommand) to run it? You shouldn't need SMO just to run an SQL script.

ChaitanyaPottam 17-Jan-14 0:34am

in my project i need to create a database in sql server, first it generates a script from existing database and then it executes the generated script to create a database in sqlserver.

one more thing Ron, i am able to do this work in a WPF application. the wpf application is of framework 4. by using the same tags in App.config i have achevied the database creation. but when i ported the same code to a wcf service i am unable to resolve the issue. could you please explain me the possible problem why it's happening.

Ron Beyer 17-Jan-14 0:38am

When a .NET 2 application (or DLL in this case) is loaded it uses a different runtime than the .NET 4 system. In order for the two to work together it has to do something called side-by-side loading. That means that both runtimes are loaded at the same time and (I think) in the same appdomain. The reason it may work with the WPF application is that it runs at a higher trust level than your WCF service, or there may be extra restrictions on side-by-side loading for WCF services. I'm not completely sure on that.

ChaitanyaPottam 17-Jan-14 0:41am

Ron so there is no solution for this.? hey Ron can i achevie same kind of work using ADo.net class.?

Ron Beyer 17-Jan-14 0:44am

I don't see why not. I would open another question and post your SMO code and ask how to achieve the same using ADO.NET classes.

ChaitanyaPottam 17-Jan-14 0:47am

Ron i went to pastebin, there i am unable to create a new account to post my solution. could you please guide me how to post my code.?

Ron Beyer 17-Jan-14 0:49am

Is it a lot of code? If it isn't too much you can just paste it into your question.

ChaitanyaPottam 17-Jan-14 6:07am

Ron i got the solution. in case of WPF application it uses it's own App.config, where as for WCF service even though we have mentioned this tag:
<startup uselegacyv2runtimeactivationpolicy="true">
<supportedruntime version="v4.0" sku=".NETFramework,Version=v4.0">
<requiredruntime version="v4.0">

it is not added to App.config. Because WCF creates it's own config file at run time . you can see this config file in WCF test client.

so now the work around for this is we need to add the above mentioned tag at run time. the class is as fallows:

using System;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;

public static class RuntimePolicyHelper
{
public static bool LegacyV2RuntimeEnabledSuccessfully { get; private set; }

static RuntimePolicyHelper()
{
ICLRRuntimeInfo clrRuntimeInfo =
(ICLRRuntimeInfo)RuntimeEnvironment.GetRuntimeInterfaceAsObject(
Guid.Empty,
typeof(ICLRRuntimeInfo).GUID);
try
{
clrRuntimeInfo.BindAsLegacyV2Runtime();
LegacyV2RuntimeEnabledSuccessfully = true;
}
catch (COMException)
{
// This occurs with an HRESULT meaning
// "A different runtime was already bound to the legacy CLR version 2 activation policy."
LegacyV2RuntimeEnabledSuccessfully = false;
}
}

[ComImport]
[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("BD39D1D2-BA2F-486A-89B0-B4B0CB466891")]
private interface ICLRRuntimeInfo
{
void xGetVersionString();
void xGetRuntimeDirectory();
void xIsLoaded();
void xIsLoadable();
void xLoadErrorString();
void xLoadLibrary();
void xGetProcAddress();
void xGetInterface();
void xSetDefaultStartupFlags();
void xGetDefaultStartupFlags();

[MethodImpl(MethodImplOptions.InternalCall, MethodCodeType = MethodCodeType.Runtime)]
void BindAsLegacyV2Runtime();
}
}

now u need to call this calss object before execute non query as fallows:

if (RuntimePolicyHelper.LegacyV2RuntimeEnabledSuccessfully)
{
DoMySmoStuff();
}
else
{
throw new Exception("Could not load SMO");
}

so this worked for me.

after a long fighting of around 48 Hrs i got this solution.

Thanks Ron for your dedication towards this issue. i have learnt a lot from this post.

Have a good day Ron.

ChaitanyaPottam 17-Jan-14 0:55am

public class DatabaseCreationRepository
{
string scriptFilePath = string.Empty;

public string ScriptFilePath
{
get { return scriptFilePath; }
}

public string ProjectName { get; set; }

public DatabaseCreationRepository(string projectName)
{
this.ProjectName = projectName;
}

public bool GenerateAndExecuteSQLDBScript()
{
bool status = false;

try
{
if (GenerateScript())
{
if (ExecuteScript(ScriptFilePath))
status = true;
}
}
catch (Exception ex)
{
//Logger.Error("GenerateAndExecuteSQLDBScript() exception." + ex.ToString());
}

return status;
}

public bool GenerateScript()
{
bool status = false;
string serverstr = ConfigurationManager.AppSettings["Server"];
string user = ConfigurationManager.AppSettings["User"];
string password = ConfigurationManager.AppSettings["Password"];

ServerConnection conn = new ServerConnection(serverstr, user, password);

try
{
Server server = new Server(conn);

Database db = server.Databases[ConfigurationManager.AppSettings["DBName"]];
Scripter scripter = new Scripter(server);

ScriptingOptions so = new ScriptingOptions();
so.IncludeIfNotExists = false;
so.IncludeHeaders = false;
so.Permissions = false;
so.ExtendedProperties = false;
so.ScriptDrops = false;
so.IncludeDatabaseContext = false;
so.NoCollation = false;
so.NoFileGroup = false;
so.NoIdentities = false;
so.TargetServerVersion = SqlServerVersion.Version100;
so.DriAllConstraints = true;
so.Indexes = true;

scripter.Options = so;

StringBuilder script = new StringBuilder();

script.Append(ScriptObject(new Urn[] { db.Urn }, scripter));

server.SetDefaultInitFields(typeof(Microsoft.SqlServer.Management.Smo.Table), "IsSystemObject");
foreach (Microsoft.SqlServer.Management.Smo.Table tb in db.Tables)
{
if (!tb.IsSystemObject)
{
script.Append("USE [" + ConfigurationManager.AppSettings["DBName"] + "] " + Environment.NewLine + "GO " + Environment.NewLine);
script.Append(ScriptObject(new Urn[] { tb.Urn }, scripter));
}
}

server.SetDefaultInitFields(typeof(Microsoft.SqlServer.Management.Smo.View), "IsSystemObject");
foreach (Microsoft.SqlServer.Management.Smo.View v in db.Views)
{
if (!v.IsSystemObject)
{
script.Append("USE [" + ConfigurationManager.AppSettings["DBName"] + "] " + Environment.NewLine + "GO " + Environment.NewLine);
script.Append(ScriptObject(new Urn[] { v.Urn }, scripter));
}
}

server.SetDefaultInitFields(typeof(UserDefinedFunction), "IsSystemObject");
foreach (UserDefinedFunction udf in db.UserDefinedFunctions)
{
if (!udf.IsSystemObject)
{
script.Append("USE [" + ConfigurationManager.AppSettings["DBName"] + "] " + Environment.NewLine + "GO " + Environment.NewLine);
script.Append(ScriptObject(new Urn[] { udf.Urn }, scripter));
}
}

server.SetDefaultInitFields(typeof(StoredProcedure