hi friends, i had faced this problem and i found a temporary solution. Before u drag and drop your sp from .net server explorer to .dbml file just comment the body of SP and write only select statement without double quote and where condition. e.g. (in your case) select t.*, c.name as Cur_Country_Desc, b.name as Branch_Desc from entiretable t left join countries c on t.n_cur_country = c.code left join branches b on t.branch_code = b.code and make actual sp code comment and now drag and drop sp from .net server explorer to .dbml file, which will creates a class file with the SPName+"Result" in .designer.cs file which have all the fields. now just remove above code from your sp and make uncomment your actual code. now i hope this will work becouse i have tried. again remember it will return class that u can find in .designer.cs file with your SPName+"Result". Let me know u have any doubts. Regards, Tabrez Shaikh Software Developer tabrezshaikh11@gmail.com