Hi,
I've been looking for references about LINQ on OTN and can't seem to find any. Does Oracle support LINQ?
Thanks,
Pat
When using the LINQ OR Mapper is there a way to force the designer to use the SQL Meta Data to grab the default value properties and set the Auto Generated Value to True, from the default valu...
Hi,
I am new to LINQ and was wondering how I would write the following SQL query in LINQ
SELECT Sum(totalTendered)
FROM Batch
Where convert(varchar,LastUpdated,101) = '11/01/2007'
T...
I know there have been many creative solutions to the problem where the Gridview does not display its headers unless at least one row is bound but I need one for use with Linq.
I was lookin...
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 an XDocument that I dynamically create from an external set of data. I would like to bind the content of the whole document to a gridview programmatically.
The structure of the XML i...
I am converting a project that i am in the process of developing to use LINQ to SQL. My problem is a scheduled process that syncs data with a 3rd party via several XML files. I am building one...
Hello Experts,
I create a function which returns an IQueryable or IEnumerable like this:
object MyFunction()
{
var result = from Categories in dataContext.Categories
...
Convert VB.NET LINQ code to C#
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...
How do you use LINQ to select the category(ies) that has an item with code="2"?
Below is the XML
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 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...
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...
In .NET 3.5 (C#), I need to update an object in a List<T>. I get the object out of the List<T> by querying it. I want to simply overwrite the queried object with the parameter object (of the...
The below code is giving error when I want to use Count function:
var procQuery = from p in System.Diagnostics.Process.GetProcesses()
//check for processes ...
I would like to join and query an in memory query and a fresh linq query. I will try and explain.
I have a query in memory (CurrentItem.ItemClauses). I need to then join this to a fresh dat...
I am quite new to LINQ and quite nieve last week I thought it was an easy language aspect to get in to.
Anyway, i have a query that i wrote and for some reason the order by will not work on...
---Dim query = _
From order In orders.AsEnumerable() _
Where order.Field(Of DateTime)("OrderDate") > New DateTime(2001, 8, 1) _
Select order
' Create a table from the query...
How can I use LINQ to read the XML and populate the database?
I have XML which contains data in a 1..n hierarchy. The database has a foreign key relationship defined between the two tables...
I am trying to use LINQ to insert records into a table. One of my values comes from a dropdownlist.selectedvalue and is a UNIQUEIDENTIFIER data type. For some reason upon the insert, I keep ge...
I have a folder with a very large quantity of files in it.
I have written a small console application as per the code snippet using LINQ to Objects
My aim is to count the amount of files i...
reader1.read sucessfully reads ea row created with the OLESelect Statement, in the Code Loop.
However, when the last reader1 row is returned/read, the reader1.HasRows BOOLEAN Value shows 'T...
I have the Linq query below and I need to modify it so that it always returns a row even if the query returns 0 rows. Is there a way to do that? If there is no result from the query, I need ...
Hello All
I have installed VS2005 + 3.0 framework. I cannot find any reference to Linq.
Could anybody tell me please how do I use Linq in VS2005 with 3.0 framework?
Thanks in advance!
