quote:

---

Msg 6260, Level 16, State 1, Line 2
An error occurred while getting new row from user defined Table Valued Function :
System.InvalidOperationException: Data access is not allowed in this context. Either the context is a function or method not marked with DataAccessKind.Read or SystemDataAccessKind.Read, is a callback to obtain data from FillRow method of a Table Valued Function, or is a UDT validation method.
System.InvalidOperationException:
at System.Data.SqlServer.Internal.ClrLevelContext.CheckSqlAccessReturnCode(SqlAccessApiReturnCode eRc)
at System.Data.SqlServer.Internal.ClrLevelContext.AllocateNativeRequest(SmiEventSink sink, UrtCacheOptions ucoOption, Char* pwchSql, Int32 cwchSql, UrtCommandType uctType, UInt64 cbMaxSize, UInt32 cFields, UrtNativeRequest** ppNativeRequest, SqlTaskMem& stmMemory)
at Microsoft.SqlServer.Server.InProcRecordBuffer..ctor(ClrLevelContext clrlvlctxt, SmiExtendedMetaData[] columnMetaData, SmiEventSink eventSink)
at System.Data.SqlServer.Internal.ClrLevelContext.CreateRecordBuffer(SmiExtendedMetaData[] rgsmdDefinition, SmiEventSink eventSink)
at Microsoft.SqlServer.Server.SqlDataRecord..ctor(SqlMetaData[] metaData)
at DDSQLCLRWrapper.DegreeDaysSQLWrapper.<GetDegreesDayData>d__0.MoveNext()

---

quote:

---

public static void FillDegreeDayRow(object item, out SqlString date, out SqlString value)
{
KeyValuePair<string, string> kvp = (KeyValuePair<string, string>)item;
date = new SqlString(kvp.Key);
value = new SqlString(kvp.Value);
}



[SqlProcedure]
[SqlFunction(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read, FillRowMethodName = "FillDegreeDayRow", TableDefinition = "date nvarchar(200) null, value nvarchar(200) null")]
public static IEnumerable GetDegreesDayData(......)
{
...
...

DatedDataSet hddData = GetWebResponse(....);

SqlMetaData dateMeta = new SqlMetaData("Date", System.Data.SqlDbType.VarChar, 20);
SqlMetaData dateValue = new SqlMetaData("Value", System.Data.SqlDbType.VarChar, 20);
SqlDataRecord dataRecord = new SqlDataRecord(new[] { dateMeta, dateValue });


for (int counter = 0; counter < hddData.Values.Count; counter++)
{
yield return new KeyValuePair<string, string>(hddData.Values[counter].FirstDay.ToString(), hddData.Values[counter].Value.ToString());
}
}

---