[linq-c#] Forum Topics

As I am new to Linq and Entity Framework, I don't know how I add comma sepearted and left join in linq/Entity code. My Sql query is rather big and I want it to be convert in Linq/entity: Select DISTINCT SR.StudentRequestId,SR.RegistrationId,SR.Location,SR.PaymentMethod,SR.CreatedOn,C.ClassName,CC.CampusName, CASE WHEN ISNULL(TSR.StatusId,0)=0 THEN 1 ELSE TSR.StatusId END AS …

I have two tables, tblstudent having fields [studentId,rollNo,classId,studentName], tblclass having fields [classId, division,className]. The two tables are referenced by field classId. I want to fill tblstudent. Also I want the table tblClass should be filled at the same time. This is for creating reports. Can any one help me..

Hi friends., I am now try to study LINQ in C#.net which book can i refer and that is easy to learn and give perfect example code snippet

Hi, I am trying to define a 'null' LINQ Table as a global variable and then use a switch statement to deturmine what the Table should be. I am having problems defining the datatype and also assigning values to it. Hopefully the code below will explain better. [CODE] System.Data.Linq.Table table; …

So I have this code so far to parse some values from many XML files. What I can't figure out is how to declare the folder that i need it to open. I need the code to open up a folder on my c:\ that has lots of xml files …

I haven't done any sort of development for a while, but what i'm looking for is to see a simple example of an ntier application using linq. Showing BLL, DAL with roles and membership. I'm also keen on getting better with my OOP and would like to find a site …

The main problem is that I recieve the following message: "base {System.SystemException} = {"Unable to create a constant value of type 'BokButik1.Models.Book-Author'. Only primitive types ('such as Int32, String, and Guid') are supported in this context."}" based on this LinQ code: [CODE] IBookRepository myIBookRepository = new BookRepository(); var allBooks = …

[CODE] private void displayWith1Criteria(string column, string value) { Console.WriteLine("entering _1_ display method"); dbcontent = new DBtestEntities(); var studienummerQuery = from members in dbcontent.Medlemmer.Include("Retninger") where column == value orderby members.Fornavn select new { Studienr = members.Studienummer, Fornavn = members.Fornavn, Efternavn = members.Efternavn, Email = members.Email, Studiested = members.Studiested, Betaling = members.BetalingsType, …