How to convert below inner join SQL statement into LINQ statement   SELECT ca.[CUS_ADDRESS_ID]   ,ca.MASTER_CUSTOMER_ID        ,ca.[ADDRESS_1]         ,[CITY]   ,[STATE]   ,COUNTRY_CODE   ,cad.ADDRESS_TYPE_CODE   ,cad.ADDRESS_STATUS_CODE      inner join [CUS_ADDRESS_DETAIL] cad on ca.CUS_ADDRESS_ID = cad.CUS_ADDRESS_ID and cad.PRIORITY_SEQ = 0   where ca.CUSTOMER_ID = '0000026'   and assign to    public class Location {            public string CustomerNumber { get; set; }     public string City { get; set; }     public string State { get; set; }     public string Country { get; set; }     public string AddressLocCode { get; set; }     public string AddressStatus { get; set; } }
I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#.  How do you represent the following in LINQ to SQL:  select DealerContact.* from Dealer  inner join DealerContact on Dealer.DealerID = DealerContact.DealerID
I know that a similar question has been asked in:        although I didn't really understand the answer and couldn't really make it work.  However, I have tried something different. I decided to read the manual page for ls and it mentions different environment variables that can be set when dealing with the ls command. If one goes to the -G option it says to look at the CLICOLOR environment variables. I did and that one links you to documentation for the LSCOLORS environment variable. I went to it and it mentions:     "The value of this variable describes what color to use for which attribute when colors are enabled with CLICOLOR. This string is a concatenation of pairs of the format fb, where f is the foreground color and b is the background color. "   It also mentions that the default value of LSCOLORS is "exfxcxdxbxegedabagacad" and that each part specifies the color of some specific thing in the ls command. For example, the first pair ex in example specifies the color of directories. the second fx the color of symbolic links etc... e means blue and x means default "foreground".  1) First what does this mean: "when colors are enabled with CLICOLOR"?  2) What does "foreground" mean?  What must environment variables be for the ls command to color the output however I desire?    I also tried:  ls --color   But it threw me the following error:  ls: illegal option -- - usage: ls [-ABCFGHLOPRSTUWabcdefghiklmnopqrstuwx1] [file ...]   The same error happened when I did ls --color=auto: it alone also throws an error. I have no idea why, and am not sure if it was due to iTerm2 or OS X or why that happened. It seems it works on other systems... Multiple regression in R results different to simple linear regression? PWM complementary square output waveforms PWM channels in certain microcontrollers such as the SAM3X8E have two complementary square output waveforms, PWMH and PWML, per channel. What is the purpose of having two waves that are the inverses of each other? -Bash command not found appearing every time I start terminal every time I start my terminal, it always says "-bash:  .: command not found" twice.  Does anyone know how I can get rid of that? Direct observations of a black hole? Who was the piano player that Starbuck met in the bar on Galactica? Towards the end of season four, Starbuck meets a piano player in the makeshift bar on Galactica.  Now, it appears that this guy is some kind of ghost/angel like Caprica-6 and the ghost Baltar - but I have an idea that he could also be the original copy of the seventh model (Daniel). It's mentioned right in the episode before that Cavil poisoned all of the bodies that were being prepared to accept a copy of Daniel - but it's ambiguous about the fate of the original cylon with that personality. Daniel was also mentioned as an 'artist' and 'sensitive' person.  So - could it have been Daniel that helped Starbuck realise what the music meant? Upgrading straight handlebars to drop handlebars I have a two-and-a-half year old  (with a road-bike-like frame and thin tires; it's somewhere in the loosely-defined "hybrid" range) that I use to commute to work, twenty-five miles round-trip, once or twice a week. The bike has straight handlebars, and having gotten used to the idea of commuting via bike, I'm interested in upgrading to drop handlebars. It looks like I'd need new break/shift levers to go with the handlebars; the whole upgrade looks like it'd run a couple hundred dollars. This is a sizable fraction of the original cost of the bike, which leads me to wonder if I'm better off saving my money for a new bike that's a little better adapted to my use.  Is upgrading my bike's handlebars a reasonable investment? Matrix Group induction proof and order of elements question What is the relationship between symmetry and degeneracy in quantum mechanics? Let me remind you about the following classical  examples in quantum mechanics.     Example 1. Bound states in 1-dim potential V(x).   Let $V(x)$ be a symmetric potential i.e.   $$V(x) = V(-x)$$   Let us introduce the parity operator $\hat\Pi$ in the following way:   $$\hat\Pi f(x) = f(-x).$$   It is obvious that    $$[\hat H,\hat\Pi] = 0.$$   Therefore, for any eigenfunction of $\hat H$ we have:   $$\hat H|\psi_E(x)\rangle = E|\psi_E(x)\rangle = E\hat\Pi|\psi_E(x)\rangle,$$   i.e. state $\hat\Pi|\psi_E(x)\rangle$ is eigenfunction with the same eigenvalue. Is $E$ a degenerate level? No, because of linear dependence of $|\psi\rangle$ and $\hat\Pi|\psi\rangle.$   Consider the second example.     Example 2. Bound states in 3-dim a potential $V(r)$. Where $V(r)$ possesses central symmetry, i.e. depends only on distance to center.   In that potential we can choose eigenfunction of     angular momentum $\hat L^2$ for basis    $$|l,m\rangle,$$   where $l$ is total angular momentum and $m$ - its projection on chosen axis (usually $z$). Because of isotropy eigenfunction with different $m$ but the same $l$ correspond to one energy level and linearly independent. Therefore, $E_l$ is a degenerate level.      My question is if there is some connection between symmetries and degeneracy of energy levels. Two cases are possible at the first sight:   Existence of symmetry $\Rightarrow$ Existence of degeneracy Existence of degeneracy $\Rightarrow$ Existence of symmetry     It seems like the first case is not always fulfilled as shown in the first example. I think case 1 may be fulfilled if there is continuous symmetry. I think the second case is always true. Proof a $2^n$ by $2^n$ board can be filled using L shaped trominoes and 1 monomino Suppose we have an $2^n\times 2^n$ board. Prove you can use any rotation of L shaped trominoes and a monomino to fill the board completely.  You can mix different rotations in the same tililng. Java GUI repaint() problem? I have a JFrame. This JFrame contains a JButton. I click the JButton and 10 JTextFields are created.  the problem: I cannot see them until "I force a repaint()" by resizing the window. Only then do I see the JTextFields created.  CODE:  JPanel points = new JPanel();  //Creating the JTextFields: for (int i=0; i&lt;10; i++) {     JTextField textField = new JTextField();     points.add(textField); }  repaint(); this.repaint(); super.repaint(); points.repaint();     THANK YOU - after the for loop, I just called points.validate() and it worked... "Where" in careers' search seems to be broken Let's say I want to find a company in Ontario, Canada. Ok, I navigate to company pages and type ON, Canada to Where in search:        but there are no companies in there. So why if I type just Canada it finds companies in ontario; and if I type specific area (ON, CA)  it doesn't find anything ? Listing only directories in UNIX Function $f: \mathbb{R} \to \mathbb{R}$ that takes each value in $\mathbb{R}$ three times Does there exist a function $f: \mathbb{R} \to \mathbb{R}$ that takes each value in $\mathbb{R}$ three times? If not, how could I prove that such a function does not exist? How to convert a currency string to a double with jQuery or Javascript? At the moment, in major part because they are two separate post objects in the system, the excerpt and the body of a tag wiki count as two separate posts with regards to suggested edits in the queue. Mechanically, this is sane, but when it comes to handling the actual queue, it can be confusing. A body edit might consist of little more than a bed of links, which looks bad. But then an excerpt is shown that includes the rest of the data, and since excerpts can be included on the actual wiki page, it makes a lot more sense when they're taken in the same space.  And this is how they are composed, too. The actual edit interface for working on tag wikis has both the excerpt and the body on the same page. In a sense, the excerpt behaves a lot like the "title" of the wiki, if we make a parallel to normal post edits.  Thus, my suggestion (which is to say a suggestion that I repossessed from Robert Cartaino) is that when suggested edits are reviewed for tag wikis, that they be presented in a single unit, treating the excerpt the same as how a title is treated in a question edit. This way, relevant information that is crossed between the two isn't lost because they are reviewed separately. Do ISTQB/ISEB Testing Certificates prove that someone can test? I have passed the , and to be honest, I'm pretty sure that anyone could pass that exam with a couple of days of studying. My question is are these certificates really of value to my career and should I put any effort into acquiring the ? When I use ssh -X on my Mac (running OS X 10.6.7) to connect to my Ubuntu (11.04) box, I get the following warning:     Warning: untrusted X11 forwarding   setup failed: xauth key data not   generated Warning: No xauth data;   using fake authentication data for X11   forwarding.   Is there something I can do to make this warning go away?  If not, can I safely ignore it?  X11 forwarding seems to work fine, though I do see this message:     Xlib:  extension "RANDR" missing on   display "localhost:10.0".   Is that related to the warning?  (I'm guessing not.  If it's not, I'll file a new question about that.) What is the best way to iterate over a dictionary? The Most Efficient Way To Find Top K Frequent Words In A Big Word Sequence Input: A positive integer K and a big text. The text can actually be viewed as word sequence. So we don't have to worry about how to break down it into word sequence. Output: The most frequent K words in the text.  My thinking is like this.    use a Hash table to record all words' frequency while traverse the whole word sequence. In this phase, the key is "word" and the value is "word-frequency". This takes O(n) time.  sort the (word, word-frequency) pair; and the key is "word-frequency". This takes O(n*lg(n)) time with normal sorting algorithm.  After sorting, we just take the first K words. This takes O(K) time.    To summarize, the total time is O(n+nlg(n)+K)， Since K is surely smaller than N, so it is actually O(nlg(n)).  We can improve this. Actually, we just want top K words. Other words' frequency is not concern for us. So, we can use "partial Heap sorting". For step 2) and 3), we don't just do sorting. Instead, we change it to be  2') build a heap of (word, word-frequency) pair with "word-frequency" as key. It takes O(n) time to build a heap;  3') extract top K words from the heap. Each extraction is O(lg(n)). So, total time is O(k*lg(n)).  To summarize, this solution cost time O(n+k*lg(n)).  This is just my thought. I haven't find out way to improve step 1). I Hope some Information Retrieval experts can shed more light on this question.