sql server - How to specify Object type when I use a Stored Procedure? -

i've project i'm using linq sql. inside sql server, i've defined custom stored procedure called [myobjectenabled] returns object following clause:

select *  myobject  mydate not null 

but when import stored procedure datacontext, type of result object myobjectenabledresult, not myobject.

i need go datacontext.cs , edit returning type manually. every time i'll import stored procedure on datacontext, previous edits erased.

so: how can tell sql server returned type right? hope question clear.

the classes linq sql creates partial; can make separate code file myobjectenabledresult.cs , in code file have myobjectenabledresult inherit shared interface , work shared interface. same can linq sql queries myobject.

// auto-generated linq public partial class myobjectenabledresult {   public int id { get; set; } }  // auto-generated linq public partial class myobject {   public int id { get; set; } }  // own code behind - isharedinterface.cs public interface isharedinterface {   int id { get; set; } }  // own code behind - myobjectenabledresult.cs public partial class myobjectenabledresult : isharedinterface { }  // own code behind - myobject.cs public partial class myobject : isharedinterface { }  // db context var query1 = db.myobjectenabled().cast<isharedinterface>(); var query2 = mo in db.myobjects select (isharedinterface)mo;