c# - Failed To Create Assembly in MS SQL SERVER -

c# - Failed To Create Assembly in MS SQL SERVER -

i trying implement routing funcationality in ms sql server 2012 using prospatial tutorial, created c# class , build dll file.

using system; using system.collections.generic; using system.linq; using system.text; using microsoft.sqlserver.server; using microsoft.sqlserver.types; namespace prosqlspatial.ch14 { public partial class userdefinedfunctions { [microsoft.sqlserver.server.sqlfunction] public static sqlgeometry geometrytsp(sqlgeometry placestovisit) { // convert supplied multipoint instance list<> of sqlgeometry points list<sqlgeometry> remainingcities = new list<sqlgeometry>(); // loop , add together each point list (int = 1; <= placestovisit.stnumgeometries(); i++) { remainingcities.add(placestovisit.stgeometryn(i)); } // start tour first city sqlgeometry currentcity = remainingcities[0]; // begin geometry sqlgeometrybuilder builder = new sqlgeometrybuilder(); builder.setsrid((int)placestovisit.stsrid); builder.begingeometry(opengisgeometrytype.linestring); // begin linestring first point builder.beginfigure((double)currentcity.stx, (double)currentcity.sty); // don't need visit city 1 time again remainingcities.remove(currentcity); // while there still unvisited cities while (remainingcities.count > 0) { remainingcities.sort(delegate(sqlgeometry p1, sqlgeometry p2) { homecoming p1.stdistance(currentcity).compareto(p2.stdistance(currentcity)); }); // move closest destination currentcity = remainingcities[0]; // add together city tour route builder.addline((double)currentcity.stx, (double)currentcity.sty); // update list of remaining cities remainingcities.remove(currentcity); } // end geometry builder.endfigure(); builder.endgeometry(); // homecoming constructed geometry homecoming builder.constructedgeometry; } }; }

i enabled clr , when seek create assembly using above created dll:

create assembly geometrytsp 'd:\routing\my example\geometrytsp\geometrytsp\bin\debug\geometrytsp.dll' permission_set = external_access; go

i'm getting "failed create appdomain" error this:

msg 6517, level 16, state 1, line 2 failed create appdomain "master.dbo[ddl].12". exception has been thrown target of invocation.

what should reason?

try remove neamespace section

namespace prosqlspatial.ch14 { }

sql server utilize default namespace

c# sql .net sql-server clr