0

How can I make use of TableTypes in Simple.data for following query:

//Type -MyType
GId int
StartDate datetime
EndDate datetime

//Table - MyTable
Id int
GId int
Text varchar
StartDate Datetime
EndDate Datetime

Select * from MyTable T1 inner join MyType T2 on T1.GID = T2.GID
and T1.StartDate between T2.StartDate and T2.EndDate
and T1.EndDate between T2.StartDate and T2.EndDate
Milen
  • 8,697
  • 7
  • 43
  • 57
user2877802
  • 3
  • 2

1 Answers1

0

To my knowledge, none of the Simple.Data providers support a TableType. The standard fallback if you want use them would be to write a stored procedure that uses them. You then run the sproc through Simple.Data.

Dan Maharry
  • 1,499
  • 2
  • 19
  • 35