表值CLR函数与SQL日期返回类型(Table Valued CLR Function with SQL date return type)

 我正在尝试创建一个CLR（C＃）表值函数，它返回一个日期表。 
 
[SqlFunction(
   DataAccess = DataAccessKind.Read,
   FillRowMethodName = "FindDates_FillRow",
   TableDefinition = "ReturnDate date")]
public static IEnumerable BusinessDays(SqlDateTime startDate, SqlDateTime endDate)
{
    //function body
}

public static void FindDates_FillRow(
object resultObj,
out SqlDateTime returnDate)
{
    dayResult result = (dayResult)resultObj;
    returnDate = result.Date;
}
 
 上面的代码导致错误，因为SqlDateTime类型在FillRow上创建方法签名，该签名与SQL Server在给定TableDefinition属性时所期望的不同。 
 
 
 
 SQL72014：.Net SqlClient数据提供程序：消息6258，级别16，状态1，过程BusinessDays，第1行“FillRow”方法的函数签名（由SqlFunctionAttribute.FillRowMethodName指定）与表值CLR函数“BusinessDays”的SQL声明不匹配由于第1列。 
 
 
 如果我将TableDefinition更改为datetime类型，一切正常，但由于没有SqlDate类型，我该如何返回日期类型？ 这甚至是可能的还是我只需要在CLR端使用datetime并在我的SQL查询中转换为日期？ 

I'm trying to create a CLR (C#) table valued function that returns a table of dates.
 
[SqlFunction(
   DataAccess = DataAccessKind.Read,
   FillRowMethodName = "FindDates_FillRow",
   TableDefinition = "ReturnDate date")]
public static IEnumerable BusinessDays(SqlDateTime startDate, SqlDateTime endDate)
{
    //function body
}

public static void FindDates_FillRow(
object resultObj,
out SqlDateTime returnDate)
{
    dayResult result = (dayResult)resultObj;
    returnDate = result.Date;
}
 
The above code results in an error because the SqlDateTime type creates a method signature on FillRow that differs from what SQL Server expects given the TableDefinition attribute.
 
 
 
SQL72014: .Net SqlClient Data Provider: Msg 6258, Level 16, State 1, Procedure BusinessDays, Line 1 Function signature of "FillRow" method (as designated by SqlFunctionAttribute.FillRowMethodName) does not match SQL declaration for table valued CLR function'BusinessDays' due to column 1.
 
 
If I change the TableDefinition to a datetime type, everything works but since there is no SqlDate type, how can I return a date type? Is this even possible or do I just need to use datetime on the CLR side and cast to a date in my SQL query? 

原文：https://stackoverflow.com/questions/34513897