Using System.Data.Linq in a Razor view

by

You need to import the namespace into your view by adding @using System.Data.Linq at the top of your view. However if you want it in all your views then you need to add <add namespace="System.Data.Linq" /> to the web.config in your Views folder:

  <system.web.webPages.razor>
    <host factoryType="System.Web.Mvc.MvcWebRazorHostFactory, System.Web.Mvc, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    <pages pageBaseType="System.Web.Mvc.WebViewPage">
      <namespaces>
        <add namespace="System.Web.Mvc" />
        <add namespace="System.Web.Mvc.Ajax" />
        <add namespace="System.Web.Mvc.Html" />
        <add namespace="System.Web.Routing" />
        <add namespace="System.Data.Linq" />
      </namespaces>
    </pages>
  </system.web.webPages.razor>

Although not relevent to your question you should really try to move this logic out of the view and into the controller, it will make things much easier to debug and means that your presentation is separated from your business logic.

More Related Contents:

  1. Dynamic Anonymous type in Razor causes RuntimeBinderException
  2. Cascading drop-downs in MVC 3 Razor view
  3. Razor HtmlHelper Extensions (or other namespaces for views) Not Found
  4. How to do a join in linq to sql with method syntax?
  5. How to use ternary operator in razor (specifically on HTML attributes)?
  6. Checkbox for nullable boolean
  7. Razor: Declarative HTML helpers
  8. asp.net-mvc: razor ‘@’ symbol in js file
  9. ASP.NET MVC 3 Razor – Adding class to EditorFor
  10. How do I define a method in Razor?
  11. ASP.NET MVC implement custom validator use IClientValidatable
  12. Is it possible to create a generic @helper method with Razor?
  13. Razor actionlink autogenerating ?length=7 in URL?
  14. Localhost not working in chrome and firefox
  15. Complex models and partial views – model binding issue in ASP.NET MVC 3
  16. The name ‘model’ does not exist in current context in MVC3
  17. Common Table Expression (CTE) in linq-to-sql?
  18. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  19. Adding sub-directory to “View/Shared” folder in ASP.Net MVC and calling the view
  20. Does Razor syntax provide a compelling advantage in UI markup?
  21. Why doesn’t Visual Studio code formatting work properly for Razor markup?
  22. How to retain spaces in DropDownList – ASP.net MVC Razor views
  23. How to get the current view name in asp.net MVC 3?
  24. How to create a function in a cshtml template?
  25. @Html.BeginForm Displaying “System.Web.Mvc.Html.MvcForm” on Page
  26. Razor ViewEngine HTML.Checkbox method creates a hidden input. Why? [duplicate]
  27. How do I create a MVC Razor template for DisplayFor()
  28. Conditional Compilation is turned off in Razor?
  29. asp.net MVC3 razor: display actionlink based on user role
  30. linq to sql: join multiple columns from the same table

Leave a Comment