Re: Eager loading question - C# Discussion Boards

Re: Using SerializationEngine to input .obj file

2-Aug-16 20:30

You need to go back to the point in your code where the error occurred to try and establish which variable does not contain the correct value. Use a breakpoint and your debugger to stop the program just before that point and step through to see what is happening.

Pete O'Hanlon2-Aug-16 20:57

Pete O'Hanlon

2-Aug-16 20:57

Andy, when you post a question like this, it's helpful to provide a little bit more information. For instance, you're leaving us to guess where SerializationEngine comes from, so while I assume you're talking about SharpGL I can't be certain this is the case. As a hint, when you're running the application inside Visual Studio, you can get the stack trace where the exception occurs. When you get the exception dialog, choose to copy the details of the exception as this lists the full stack and gives you more of an idea where the problem is. Also, if the code you're running against is SharpGL, you can download and build it yourself and step into the code while you're debugging.

This space for rent

how to use cast linq concept

Member 100705702-Aug-16 2:27

Member 10070570

2-Aug-16 2:27

listshop = (from d in dbcontext.Customers where d.CustomerId==clsCommon.Custid & d.ReservedField3!="InActive"
                                        select new ClsPurchaseOrder
                                        {
                                            CustomerId = d.CustomerId,
                                            CustomerName = d.CustomerName,
                                            ReservedField6=d.ReservedField6
                                        }).ToList();
                            listshop.OrderBy(x => int.Parse(x.ReservedField6)).ToList();

Re: how to use cast linq concept

OriginalGriff2-Aug-16 2:42

OriginalGriff

2-Aug-16 2:42

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
So where are you stuck? What have you tried? What help do you need?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Eager loading question

Member 93644551-Aug-16 21:53

Member 9364455

1-Aug-16 21:53

I have a question about eager loading of navigation properties using EF6. Note I like to use the extension syntax.

Suppose I have three tables A, B and C. There is a one-to-many relationship between A and B, and also a relationship between B and C. So, for a given A, I can obtain the collection of Bs using two methods:

Method 1 : using a primary key query...

var Bs = context.B.Where(b => b.AId == A.Id).ToList();

Method 2 : using the navigation property...

var Bs = a.Bs.ToList();

Now, suppose I want to load C for each B at the same time. Using Method 1 it is...

var Bs = context.B.Include(b => b.C).Where(b => b.AId == A.Id).ToList();

My question is, is there an equivalent simple way to load C for each B when using Method 2?

Re: Eager loading question

Nathan Minier2-Aug-16 2:58

Nathan Minier

2-Aug-16 2:58

A lot of the time this is based on the serializer that you're using. JSON.NET, for instance, will do this automatically when serializing an IQueryable. Depending on your serialization strategy, you may need to roll your own.

If you need to work with it in intermediate logic, any queryable references will be resolved automatically as long as is not disposed when you attempt to call them. Just don't force enumeration on the collection until you actually need the data item.

Something like

var b = context.As.SelectMany(a => a.Bs); //flattens our multi-dimensional array
var c = PerformSomeLogicOnEnumerable(b);
return c.ToArray();

"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli

Re: Eager loading question

Agent__0073-Aug-16 18:52

Agent__007

3-Aug-16 18:52

If I am not wrong, you need all A, B and relevant C's? Give this a try (where "B" is a collection of B's as a property of "A", and likewise "C" is a collection of C's as a property of "B"):

var abc = context.A.Include("B").Include("B.C");

You have just been Sharapova'd.

Daniyaltjm1-Aug-16 20:49

1-Aug-16 20:49

modified 23-Jun-20 3:35am.

Richard MacCutchan1-Aug-16 22:11

1-Aug-16 22:11

Which password are you talking about, the router or some website? In either case it is likely that the only way to check is by trying to login via the web interface.

...

Daniyaltjm1-Aug-16 22:14

1-Aug-16 22:14

...

modified 23-Jun-20 3:36am.

OriginalGriff1-Aug-16 22:41

OriginalGriff

1-Aug-16 22:41

We do not condone, support, or assist in the production of malicious code in any way, form, or manner. This is a professional site for professional developers.

If you want to know how to create such things, you need to visit a hacking site: but be sure to disable all firewalls and antivirus products first or they won't trust you enough to tell you.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Message Closed

1-Aug-16 22:46

1-Aug-16 22:46

Message Closed

modified 23-Jun-20 3:35am.

OriginalGriff1-Aug-16 22:50

OriginalGriff

1-Aug-16 22:50

Daniyaltjm wrote:
i want to hack the wi-fi router by brutforce

That is trying to bypass a legitimate security feature.
That is malicious.
You will get no help from us.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Message Closed

1-Aug-16 23:05

1-Aug-16 23:05

Message Closed

modified 23-Jun-20 3:37am.

Pete O'Hanlon2-Aug-16 0:34

Pete O'Hanlon

2-Aug-16 0:34

OriginalGriff is right. You might think that you have a legitimate reason for wanting to do this (although I remain to be convinced about this) but you wouldn't be the only one able to read the answer and, if we provide you with code to do this, we are also providing the code for people who want to do damage with this technique. This is why you will get no code for this here - we don't know who will end up reading it.

This space for rent

Richard MacCutchan1-Aug-16 23:03

1-Aug-16 23:03

I already suggested you just need to use the web interface to try and login. If your password is not valid it will not let you. But if you want to know how to hack a system then you have come to the wrong place.

Message Closed

1-Aug-16 23:11

1-Aug-16 23:11

Message Closed

modified 23-Jun-20 3:40am.

Richard MacCutchan1-Aug-16 23:19

1-Aug-16 23:19

You check WiFi passwords by logging on to the ADSL modem/router through the web interface of the device. I guess you have never done this so you think there is some other way to hack the device.

Daniyaltjm1-Aug-16 23:38

1-Aug-16 23:38

No, i don't want connect the setup interface router! just i want for example: i have a textBox and into it is "1234" pass & i have a button . i want when click the button the "1234" in the textBox send to the my SSID for example "USER" & return "correct" or "incorrect" the pass ! It is very complicated ? Laugh | :laugh:

please help me...

Richard MacCutchan2-Aug-16 0:36

2-Aug-16 0:36

Daniyaltjm wrote:
It is very complicated ?

See C# WPF how to connect a wifi with password - Stack Overflow[^].

Daniyaltjm2-Aug-16 1:04

2-Aug-16 1:04

Very thank's, can you build a simple program that has a listBox to show SSID & a textBox that i enter a password & click the button & return me a messagebox that this is correct or incorrect ? Big Grin | :-D

Richard MacCutchan2-Aug-16 1:09

2-Aug-16 1:09

Ha ha, nice try.

Daniyaltjm2-Aug-16 3:21