没有映射从对象类型WebMatrix.Data.DynamicRecord存在一个已知的托管提供原生型 [英] No mapping exists from object type WebMatrix.Data.DynamicRecord to a known managed provider native type

问题描述

我很困惑与我的SQL服务器返回错误 - 这将是导致此

I am very confused with the error my SQL server is returning - what would be causing this?

我运行的C＃代码是：

List<CalendarEvent> events = new List<CalendarEvent>();
        var db = Database.Open("myDatabase");
        string username = HttpContext.Current.Request.Cookies.Get("username").Value;
        var listOfGroups = db.Query("SELECT GroupID FROM Membership WHERE UserID = (SELECT UserID from Users WHERE Username = @0 )",  username);

        foreach(var groupID in listOfGroups)
            {
                var result = db.Query(
                    @"SELECT e.event_id, e.title, e.description, e.event_start, e.event_end, e.group_id, e.recurring
                    FROM   event e
                    JOIN   Membership m ON m.GroupID = e.group_id
                    WHERE  e.recurring = 0
                    AND    m.GroupID = @0
                    AND    e.event_start >= @1
                    AND    e.event_end <= @2
                    UNION ALL
                    SELECT e.event_id, e.title, e.description, DATEADD(week, w.weeks, e.event_start), DATEADD(week, w.weeks, e.event_end), e.group_id, e.recurring
                    FROM   event e
                JOIN   Membership m ON m.GroupID = e.group_id
                CROSS JOIN 
                    ( SELECT  row_number() OVER (ORDER BY Object_ID) AS weeks
                    FROM SYS.OBJECTS
                    ) AS w
                    WHERE  e.recurring = 1
                    AND    m.GroupID = $3
                    AND    e.event_start >= @4
                    AND    e.event_end <= @5", groupID, start, end, groupID, start, end
                );
                foreach(var record in result)
                    {
                            CalendarEvent cevent = new CalendarEvent();
                            cevent.id = record.event_id;
                            cevent.title = record.title;
                            cevent.description = record.description;
                            cevent.start = record.event_start;
                            cevent.end = record.event_end;
                            cevent.recurring = record.recurring;
                            events.Add(cevent);
                    }
            }
        return events;
}

和错误：

异常详细信息：System.ArgumentException：从
对象类型WebMatrix.Data.DynamicRecord不存在任何映射到一个已知的托管提供
机类型

Exception Details: System.ArgumentException: No mapping exists from object type WebMatrix.Data.DynamicRecord to a known managed provider native type.

什么可能会造成这一点，我怎么能解决这个问题？

What could be causing this and how can I fix it ?

我希望做的是回到那里经常性= 0的所有事件，并在经常性= 1我要为他们一周要返回的所有事件和52周一次。

What I wish to do is return all events where recurring = 0, and any events where recurring =1 I want to be returned for their week and the 52 weeks thereafter.

推荐答案

看起来像你的问题是与你的 GROUPID 输入参数。

Looks like your issue is with your groupID input parameter.

var listOfGroups = db.Query("SELECT GroupID FROM Membership WHERE UserID = (SELECT UserID from Users WHERE Username = @0 )",  username);

您 listOfGroups 是回来作为一个集合的 WebMatrix.Data.DynamicRecord 的对象。你似乎只想在 INT 价值，当你 GROUPID 在的foreach（VAR 。GROUPID在listOfGroups）语句

Your listOfGroups is coming back as a collection of the WebMatrix.Data.DynamicRecord objects. You seem to want just the int value, as you get groupID in the foreach(var groupID in listOfGroups) statement.

尝试，而不是替换最后一行：

Try instead replacing the last line:

AND    e.event_end <= @5", groupID, start, end, groupID, start, end

与

AND    e.event_end <= @5", (int)groupID.GroupID, start, end, (int)groupID.GroupID, start, end

这应该拉从每个动态查询结果的第一（唯一的）列中的值，该值是，你是后整型组ID。



的编辑：的DynamicRecord查询结果的修正值调用语法

This should pull the value from the first (and only) column of each dynamic query result, that value being the int group ID that you are after.

Corrected value call syntax of DynamicRecord query result.

这篇关于没有映射从对象类型WebMatrix.Data.DynamicRecord存在一个已知的托管提供原生型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！