|
Hello all,
Is there a online system which converts SQL - LINQ or can anyone else help convert the SQL - LINQ below?
SELECT MIN(startTime) As startTime, MAX(endTime) As endTime FROM tblRA LEFT JOIN tblA ON tblRA.asID = tblA.asID WHERE ' ' BETWEEN tblRA...
Started by ClareBear on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I think your code is a little bit incorrect, and the first symptom of it is ... .
Clare
You may find the Linq in Action book helpful .
Try this: http://www.sqltolinq.com/
I didn't find an example in the end, so decided to do it within a stored procedure .
|
|
(I believe this is the same problem as this one , but there's no answer there, and I think I can express the problem better here...)
I have two Linq-to-SQL classes, State and County , where County has a FK to State . Here's some test code:
State s = State...
Started by Shaul on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In which case, the correct way of doing this is:
State s = State.GetState("NY"); // here I do a load of a State class via the Linq DataContext County c = new County... .
I'm assuming State -> Count is a one to many relationship .
Something isn't right here.
|
|
On Thu, 23 Jul 2009 15:12:43 +0100, "David" <david.colliver.NEWS@revilloc.REMOVETHIS.com
Hi,
I am using Linq to Sql.
I have a linkbutton in an AJAX update panel.
The link button on click has...
using (DataClassesDataContext dc = new ...
Started by David on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Thu, 23 Jul 2009 18:24:07 +0300, "Coskun Sunali [MVP]" <Coskun@Sunali.com
Hi David,
Did you try profiling the SQL database to see if you query goes there at
all?
--
Coskun Sunali
Microsoft MVP - ASP.NET
http://sunali.com
http://propeople.... .
|
Ask your Facebook Friends
|
I have this class
public class Line { public string ConnectionsIndex{get;set;} }
my Linq problem is that I have to aggregate these Lines
var l1 = new Line{ ConnectionsIndex="01,02"}; var l2 = new Line{ ConnectionsIndex="02,03"}; var l3 = new Line{ ConnectionsIndex...
Started by Mauro Destro on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Something like:
var connections = (from line in lines from connection in line.Split(',') select connection).Distinct() .ToArray(); Line line = new Line { ConnectionsIndex = string.Join(",", connections) };
This doesn't order the connections, but you can... .
|
|
I have the following problem: in a database table are Sales recorded. One of the field is the SaleDate which is a SQL Server Date type. The Website now allows to search in this field. And it allows to search only for the year.
Let's assume there is one...
Started by Michael on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Especially the last one but essentially you want to test the year... .
Have you tried something like
s => s.SalesDate == Date.Parse("01 November 2008")
or
s => s.SalesDate == Date.Parse(MyDate)
or
s => s.SalesDate.Year == "2008"
Above is untested .
|
|
Seeing as though I've now solved all of my LINQ problems I'm not working on developing an actual model. The thing is with this is that I do not want to be tied in to a single technology, I want to have freedom to implement different data access technologies...
Started by Kezzer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you want true repository abstraction, you could have a separate Contract type that is nothing to do with your ORM tool, and return... .
It doesn't exactly advertise the real return type to the caller .
The IMultipleResults to me sticks out like a sore thumb .
|
|
I want to enable the user to highlight a row on the WPF DataGrid and press delete key to delete the row.
the functionality is already built into the UI of the grid, so to the user, the row disappears I currently handle this on the SelectionChanged event...
Started by Edward Tanguay on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Private void OnKeyDown(object sender, KeyEventArgs e) { if ( Key.Delete == e.Key ) { // Delete pressed } }
The RemovedItems items reflects the items removed from the ... .
You want to handle the KeyUp or KeyDown event and check the pressed Key for Delete .
|
|
On Thu, 12 Feb 2009 13:16:15 +0100, "Ivan" <vbnewbie@hotmail.com
Hi,
I've got a problem with a query I make using Linq. The problem is that I
want to show the results in a DataGridView. Until now I had used it without
problems using CopytoDataTable...
Started by Ivan on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Fri, 13 Feb 2009 21:42:42 +0100, "Michel Posseth [MCP]" <MSDN@posseth.com
Hello Ivan ,
This is a copy paste from one of my reall life projects
<SNIPPrivate Sub FilterOnDgvObject(ByVal ObjectNr As Decimal)
Me.Cursor = Cursors.WaitCursor... .
|
|
On Tue, 21 Jul 2009 15:05:49 +0100, "David" <david.colliver.NEWS@revilloc.REMOVETHIS.com
Hi all,
Still trying to understand Linq at the moment. Parts of the project, I am
still using Sql queries because of my limited knowledge of linq.
A problem...
Started by David on
, 7 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Tue, 21 Jul 2009 12:37:41 -0500, "SyntaxError" <visit@marcone.com
var qry = from sheetRow in context.ServiceSheets
join trailerRow in context.TrailerDetails
on sheetRow.TrailerID = trailerRow.TrailerID into joinTable
from result in... .
|
|
Currently I have a DataGridView in my app which I fill from my Linq-to-SQL classes like so ...
/// <summary> /// Delegate to update datagrid, fixes threading issue /// </summary> private void updateInfo() { // Linq to datagridview; display...
Started by Emil on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Regardless of how you are updating your underlying.
I do not think this is a LINQ problem.
But similar).
|
