Some long-gone developer left the following LINQ query behind with no documentation and I'm struggling to understand what it does (and therefore if it's doing it right), either by breaking it into pieces or providing the SQL equivalent?
CODE:
I am struggling in particular with the Group Join and Into TargetMatches = Group pieces:
CODE:
translation of the following C# Linq Expression (in VB.NET 2008):
syncContext.Send((obj) => eventToBeFired(this, new EventArgs()), null);
Is used in this subroutine:
private void FireEvent(EventHandler eventToBeFired)
{
if (eventToBeFired != null)
{
[code]....
I have a table that contains procedure codes among other data (let's call it "MyData"). I have another table that contains valid procedure codes, their descriptions, and the dates on which those codes are valid. Every time I want to report on MyData and include the procedure description, I have to do a lookup similar to this:
From m in dc.MyDatas _
Join p in dc.Procedures On m.proc_code Equals p.proc_code _
Where p.start_date <= m.event_date _
[Code]....
Is there a way to turn a complex lookup (i.e. a non-trivial join) like this into something SQL can recognize so that I can define it in one place and just reference the description as if it were a field in MyData? So far the only thing I can think of is to create a SQL view on MyData that does the linking and bring that into my data context, but I'd like to try to avoid that.
The following LINQ query resp. call of the extension method Select in Visual Basic 2010 is working fine:
Dim qAvSalary = qJobData.Select(Function(e) e.AvSalary) But doing so I am not able to specify the name of property I want the query (e.g. AvSalary) using a string variable. This should be possible if I use a LINQ expression tree. Searching and trying a long time on how to translate the query to a corresponding expression tree was not successful. My final approach is:
[Code]...
I'm trying to convert something from C# to VB.NET and I'm having trouble finding an equivlent in VB.NET to C#'s yield keyword. I realize 'yield' is not a convertable keyword to VB.NET, so can someone please show me how I would implement this code in VB.NET. I got all of it converted over except for the implemented GetEnumerator() function. It is simply a class that implements CollectionBase and IEnumerable (to make it LINQ worthy):
[Serializable()]
public partial class Customers : CollectionBase, System.Collections.Generic.IEnumerable<BusinessLayer.Customer>
{
[code]....
I have the following query in VB, but I do not know how to translate it to C# synatax
Dim q = From c In db.Customers
Group Join o In db.Orders On c.CustomerID Equals o.CustomerID Into orders = Group
Select New With {c.ContactName, .OrderCount = orders.Count()}
Is there a LINQ To SQL equivalent to the SQL between keyword?[code]...
View 2 RepliesFind the Linq equvalent on the below sql query:
select sum(weight) from (
select weight from pers p
join list l on l.persindex= p.persindex
group by p.persindex,weight) a
This is the query that I'm trying to reproduce:
[Code]...
Not sure if this is just a bad habit, or a valid way of doing things, but for large complex report queries spanning bunches of tables, I often get my aggregate stats by summing a Case statement.For example:
SELECT Contact.Name,
SUM(CASE WHEN Order.Type = 'Special' THEN 1 ELSE 0 END) AS SpecialOrders,
SUM(CASE WHEN Order.Type = 'Magic' THEN 1 ELSE 0 END) AS MagicOrders,
[code].....
Is there a VB.NET equivalent to the C# var keyword? I would like to use it to retrieve the result of a LINQ query.
View 4 RepliesI'm trying to translate some C# LINQ code into VB.NET and am stuck on how to declare an anonymous type in VB.NET.[code]How do you translate C#'s new { ... } syntax into VB.NET?
View 2 RepliesI'd normally do this in C# but since I've got to get this code in this particular assembly which is a vb.net one, I'm stuck.
Here's my linq query:
Dim i As Integer = 0
Dim oldAndCurrentIntersectionOnNames = From currentApplicant In currentApplicants _
Group Join oldApplicant In oldApplicants _
[CODE]...
You'll see the .Index = i+=1
This was my attempt to do what I'd quite happily do in C# (i.e. Index = i++) in VB. Unfortunately the VB compiler doesn't like that. how I'd do this in VB.
I want to repeat a random number sequence generated by a legacy software using the VBMath.Rnd and VBMath.Randomize functions in VB .NET Reading on the documentation for those functions on MSDN i found that you are supposed to "reset" the generator calling Rnd with a negative value if you want the same seed to give you the same result sequence each time. But doing some tests... things didn't work as expected.
[Code]...
c# - Obscure VBMath random numbers generator behavior
View 2 RepliesHow do you convert the following c# code to vb.net?
[Code]...
I have found aa solution to a problem in one of my reports but its in VB.NET and I am not sure how to convert it to C#, I tried to do it online with one of the tools but it cant determine the events been used or something like that. If there is anyone savy at both languages maybe you can help me figure out its translation?
Here is the VB code:
Private Sub XrLabel1_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
Handles XrLabel1.BeforePrint
CType(sender, XRLabel).Tag = GetCurrentColumnValue("ID")
[CODE]...
I tried to convert it on this site [URL]
THE ORIGINAL CODE IS FOUND HERE [URL]
How can i translate this code to vb6? i have already searched in google for translators, but with no success;.
Private Sub CallFunction()
If Me.bOn Then
Me.connectionString = String.Concat(New String() { "Server=", Me.strIP, ",1433;Network Library=DBMSSOCN;Database=rPTDB;UID=", Me.strUser, ";PWD=", Me.strPassword, ";" })
[code]....
I have this little function for forcing a download of MP3 files. I have it integrated into my VB app but would like it to be converted from C# to VB so that I can use other functions in my APP_Code directory.
[code]...
Is there an English - Visual Basic dictionary thae translate my thoughts to code? I am taking courses at the local community college and having difficulty with this "foreign" language.
View 4 RepliesTranslate c# to program?[cod]e...
View 1 RepliesI have found the following code which can get the harddisk no in VB6.0.I would like to translate it into vb.net code.I have tried the auto upgrade function in vb2005 and translated the following code to vb.net, but the outcome did not run probably.Can anyone give me some help to translate the following VB6.0 code into vb.net code?
[Code]...
I am currently trying to use a vb function in c#, i have to translate the following from vb to c#:
For index = LBound(CollectionChannelPanel.EkItems) To UBound(CollectionChannelPanel.EkItems)
I need a hand with something i need to translate the following code to VB...
[Code]...
im having some difficutly with syntax etc.
I am looking at this blog, and I am trying to translate the snippet to VB.
I'm having difficulties with this line:
NotifyCollectionChangedEventHandler handlers = this.CollectionChanged;
NOTE: CollectionChanged is an event of this ('this' is an override of ObservableCollection<T>).
public void Attach()
{
deviceHandle = capCreateCaptureWindow(string.Empty, WS_VISIBLE | WS_CHILD, 0, 0, (int)this.ActualWidth -150, (int)this.ActualHeight, new WindowInteropHelper(this).Handle, 0);
if (SendMessage(deviceHandle, WM_CAP_DRIVER_CONNECT, (IntPtr)0, (IntPtr)0).ToInt32() > 0)
[code]....
So, I'm taking Intro to Programming and I'm working through the exercises in a chapter about String Manipulation and the For Next loop.We haven't gotten to arrays yet, so I'm trying to do this just with what's been covered.The exercise is to translate a word into pig latin.If it begins with a vowel, you add "-way" to the end of the string. If it doesn't, you add "-" and then the first character to the end until you reach a vowel and "ay" to the end of that. So "Chair" would become "air-Chay".[code]
View 4 RepliesI am trying to translate some VB codes to C++. And I am not quite sure what this line does.
IIf (n& 1=1, 0.0005, -0.0005)
I know what IIf(logic, true_value, false_value) does, and I guess the & operator is supposed to concat two strings. But I am not sure what the intention of using "n & 1 =1".
I need to translate this C# code in VB.NET 2005:
[code]...
I'm trying to convert old VB.NET code into C# and I'm not sure about the current line and what it means really.
[Code]....