فراخوانی تابع در انتتی فریم ورک

[karim.mashayekhi]

با سلام
من توی برنامه ام از انتتی فریم ورک استفاده میکنم و یه تابع توی اس کیو ال نوشتم که زمان رو به تیک تبدیل میکنه
زمانی که میخام این تابع رو بیارم توی ویزال استدیو گزینه اش غیر فعاله
اصلا نمیدونم چجوری میشه ازش استفاده کرد
ALTER FUNCTION [dbo].[Tick2Time]
(
--@TickValue as bigint
@Ticks as bigint
)
RETURNS DateTime2
AS
BEGIN


--Declare @Days float



--Select @Days = @TickValue * POWER(10.00000000000,-7) / 60 / 60 / 24

--return (Select DATEADD(d, Cast(@Days As int), Cast('0001-01-01' As DATE))
-- + Cast( (@Days - FLOOR(@Days)) As DateTime))


declare @TickPerSecond as bigint = 10000000
declare @TickPerMinute as bigint = 60 * @TickPerSecond
declare @TickPerHour as bigint = 60 * @TickPerMinute
declare @TickPerDay as bigint = 24 * @TickPerHour
declare @D as bigint = @Ticks / @TickPerDay
declare @H as bigint = (@Ticks % @TickPerDay) / @TickPerHour
declare @M as bigint = ((@Ticks % @TickPerDay) % @TickPerHour) / @TickPerMinute
declare @S as bigint = (((@Ticks % @TickPerDay) % @TickPerHour ) % @TickPerMinute) / @TickPerSecond
return dateadd(second, @S, dateadd(minute, @M, dateadd(hour,@H, dateadd(day, @D, cast('0001-01-01T00:00:00' as datetime2)))))


--return dateadd(MICROSECOND,cast(@Ticks / 10 as bigint), cast('0001-01-01T00:00:00' as datetime2))


END

149158