stored procedures - C# ExecuteQuery null value -

I have some code:

  using (OAZISDBDataContext ctx = new OAZISDBDataContext () ) {IEnumerable & LT; DBContactDetail & gt; Details = ctx.ExecuteQuery & lt; DBContactDetail & gt; ( ". Passing the executive [dbo] [zna_contact] {0}, {1}", "test", "19,601,023",}  

I also though store empty values ​​methodology If you want to be able to, because it does not use them.

now with strings it is easy, I just can not have string. empty and it will work. but if I have free dates it the problem is to have

I obviously tried: the

  Using (OAZISDBDataContext ctx = new OAZISDBDataContext ()) {IEnumerable & LT; DBContactDetail & gt; Description = ctx .. ExecuteQuery & LT; DBContactDetail & gt; ( "Executive [dbo] [zna_contact] {0}, {1}. "," Test ", null,}  

but this does not work 'error:

System.Exception: a queryparameter type system. Object can not be done

After reading something I found that ExecuteCommand does not support the null parameter while PEC claimed it should

Also faced this issue and Has a solution been found?

Thanks a bunch

you have tried:

  Dbnulkvalu