I would like to know how to convert this SQL Query into a LinQ equivalent:
SELECT nContractDeliverables.* FROM (nContractDeliverables INNER(Join) nContractPaymentLines ON (nContractDeliver...
Ok.. I've tried all the examples on MSDN and other sites but nothing seems to work.
I want to query a data table and find out how MANY rows match the selection criteria. using LINQ to data...
It appears the following code cause a problem that took me an hour and half to find the solution to. There was only one related artice on the web I could find, so I thought I would post the p...
My Project: Windows Form App written in C# VS2008
I am seeking some advice and possible example for the following dilemma. I am new to Linq To Sql and Linq To DataSet and I am trying to find ...
I have 3 tables (that matter in my DB)
FantasyTeams
-FantasyTeamId PK
-TeamName
PitcherTeamMatrix
-MatrixId PK
-FantasyTeamId
-PitcherId
Pitchers
-PitcherId
-PitcherName
-W...
I am merely attempting to convert a string of a date to a DateTime object in a LINQ query. The code is as follow, can anyone familiar with LINQ assist me? I have a hard coded example that I ca...
Hi,
I have a class that is currently designed to work as follows:
Customer c = Customer.GetByID(5);
c.Name = "John Smith";
c.Save();
I'm moving to linq, so I designed my Customer cl...
I have an interesting occurence here... I have fairly basic code (using LINQ for entities with the MS entity framework beta from December) which compiles fine in one class. In another class, i...
I am new with Linq to Sql.
I don't want to use "for each next",
because I am returning one record.
I tried,
Dim db As New Ticket_JCDataContext
Dim ThisTicket = (From t In ...
I would like to concantenate two database fields to make a first-last name string for an end result in a search. I am trying to use the sql server wildcard with LINQ. Can anyone see what I am ...
I want to query a table and return a list of distinct people. BUT I do not want empty entries that will given a blank line in the combobox
e.g
Dim person =From p In Db.CDRs Select p.Appr...
Hi,
I am using LINQ to SQL, and one thing I don't like about it, is that it automatically adds connectionstring to my .config file and use a connection string key in the generated code, si...
I am trying to convert a NOT IN sub query into the LINQ definition but can't fugure it out. Anyone have an idea?
SELECT * FROM Permissions
WHERE
Permission_ID NOT IN (
SELECT Permissio...
I have the following XML file.
I want to query this XML file to retreive the name attribute of the Group Element, given a Microsite name.
How do I do this in LINq?
Is LINq the best way to d...
How can I combine results from two data sources? The problem is that the second datasource result set is the 'current' data in the binding source and the first is the results that are showing...
I have SQL Server 2005 installed. I am wondering if there is anyway to get LINQ to work in SQL Server 2005. I also have Visual Studio 2005, unintalled, but I could install it.
I understan...
Hi all,
I'm trying to call a stored procedure from LINQ. The sproc has an optional Integer parameter that defaults to null.
When I try to call it with the code below I get the following ...
I'm using LINQ to develop a website, i'm doing the DataContext.SubmitChanges() for Update, Delete, Insert. Is there a way for me to retrieve the Id of the newly inserted record without queryin...
I have a dbml file that I had created that represents my data quite nicely...for querying anyways -- LINQ to SQL is so nice!
however I've run into a problem:
In my .dbml file I've added ...
I have a query which I would like to port to LINQ
I have so far got the query formed but i need to get it strongly typed so i can pass it around to a view in the asp mvc framework
The Ca...
I have a joined linq query which of course returns an anonymous type. Can I specify that i only want to return results from one of the tables e.g.
Dim Valleys = From p In _dbProduct.Products...
Hello, Im about to start a new website and the requirement is to build a Web Service that will be consumed by the website, for this web service i intend to use 3.5, I'll be using Linq to hand...
I am curious how I can go about doing the following. I am creating an application that is similar to the custome data filter on excel. Here is an example of how the custom data filter would wo...
Just looking for books that people can recomend that give more advanced details on Linq, I don't need an introduction to Linq
Purpose is use it as a reference book when writing code.
I have a use control that contains a GRIDVIEW. I am trying to programmatically bind the gridview to a LINQ query.
The linq query DOES return data. I verified this with a Visualizer for VS2K8....
