前兩天Insus.NET實現一個功能《在數據庫中提供只讀數據》http://www.cnblogs.com/insus/p/4384411.html ,在數據庫中為程序提供靜態數據。它是在Clr存儲過程實現?，F想使用另外一種方式來解決。如果提供這些靜態數需要與其它數據結合Join等，這樣象前面的存儲過程，有些不太好操作。那我們可以把它實現在table-valued function。創建一個model:

再創建一個Entity:

打開SqlFunction類，編寫table-valued函數：

可復制代碼：

 [SqlFunction(Dataaccess = DataAccessKind.None,                FillRowMethodName = "FillRow_1A",                TableDefinition = "Id TINYINT,Name NVARCHAR(30), [key] NVARCHAR(30)")   ]    public static IEnumerable Tvf_SiteInfor()    {        FruitEntity fe = new FruitEntity();        return fe.GetData();           }    PRivate static void FillRow_1A(object source, out SqlByte id, out SqlChars name, out SqlChars key)    {        Si obj = (Si)source;        id = new SqlByte(obj.Id);        name = new SqlChars(obj.Name);        key = new SqlChars(obj.Key);    }

部署至SQL：可復制代碼：

IF EXISTS (SELECT * FROM sys.objects WHERE name = 'Tvf_SiteInfor')    DROP FUNCTION Tvf_SiteInfor;GOIF EXISTS (SELECT * FROM sys.assemblies WHERE name = 'FruitClr')    DROP ASSEMBLY FruitClr;GOCREATE ASSEMBLY FruitClrFROM 'E:/FruitClr.dll' WITH PERMISSION_SET = SAFE;GOCREATE FUNCTION Tvf_SiteInfor() RETURNS TABLE(    Id TINYINT,    [Name] NVARCHAR(30),    [key] NVARCHAR(50)) AS EXTERNAL NAME [FruitClr].UserDefinedFunctions.Tvf_SiteInfor; GO

執行結果：