Search code examples
c#.netasp.netsingle-file

Single-file ASPX and LINQ


there's a CMS system and there's aspx page without backend file. I can add server code straight to the .aspx wrapped with <script language="C#" runat="server"> tag. But compiler generates an error because I use LINQ in my code and I don't have using System.Linq; statement anywhere. And I can't add using inside .aspx file (error again). What should I do?

<%@ Page Inherits="MyPage" MasterPageFile="~/Master.master" %>
<script language="C#" runat="server">
[System.Web.Services.WebMethod]
public static List<string> GetA()
{
    MyDataContext db = new MyDataContext();

    var result = from a in db.A
                 select a;

    return result.ToList();

}
</script>

Solution

  • Add

    <%@ Import Namespace = "System.Linq" %>
    

    Above the code should work.

    So final code should look like

    <%@ Page Inherits="MyPage" MasterPageFile="~/Master.master" %>
    <%@ Import Namespace = "System.Linq" %>
    <script language="C#" runat="server">
    [System.Web.Services.WebMethod]
    public static List<string> GetA()
    {
        MyDataContext db = new MyDataContext();
    
        var result = from a in db.A
                     select a;
    
        return result.ToList();
    
    }
    </script>