Linq Left outer join to two tables
LEFT OUTER JOIN in LINQ
SD Card showing weird file names and files are lost I just plugged my SD Card to my PC after a long videography day, and I suddenly got this problem:    It is also not showing all the videos I took on my camera so what is the solution? How to make the tick thickness as the axis line? I am trying to make the thickness of the ticks equal to the axis line thickness. That is what I have so far:  \documentclass{article}   \usepackage{pgfplots}  \pgfplotsset{compat=1.5}   \begin{document}     \begin{tikzpicture}     \begin{axis}[         xlabel=Binding Energy (eV),         ylabel=Intensity (a.\,u.),         xtick pos=left,         x dir= reverse,         ytick = \empty,         every x tick/.style={color=black, thin},         tick align=outside,         xlabel near ticks,         ylabel near ticks,         xmin = 96,         xmax = 108     ]         %\addplot[mark=none] table[x=BE,y=cnts] {si2p.txt};         % This data looks similar:         \addplot[mark=none, smooth] table[x=BE,y=cnts] {             BE      cnts             95      1             98      1             99      10             99.5    5             100 6             101 2             108 2         };      \end{axis}     \end{tikzpicture} \end{document}     But if you take a closer look on the ticks on the outside, you'll see that they are somehow clipped or a least thinner. They are also black so the style seems to work for them.    Is this a bug or can I change the clipping region? And as a second question: is thin the correct value for the thickness? Let $n$ is a natural number. Prove that $$\left\lfloor\frac{n}{1}\right\rfloor+\left\lfloor\frac{n}{2}\right\rfloor+....+\left\lfloor\frac{n}{n}\right\rfloor+\left\lfloor{\sqrt{n}}\right\rfloor$$   is even.   I used induction and the inequality $$x-1&lt;\lfloor{x}\rfloor\le{x}$$ to prove it.  Is there any other, nicer way to do it? YA dystopia novel of battle school with unusual military control scheme Creating a DateTime in a specific Time Zone in c# I'm trying to create a unit test to test the case for when the timezone changes on a machine because it has been incorrectly set and then corrected.  In the test I need to be able to create DateTime objects in a none local time zone to ensure that people running the test can do so successfully irrespective of where they are located.  From what I can see from the DateTime constructor I can set the TimeZone to be either the local timezone, the UTC timezone or not specified.  How do I create a DateTime with a specific timezone like PST? I am looking for a book that goes through the mathematical aspects of neural networks, from simple forward passage of multilayer perceptron in matrix form or differentiation of activation functions, to back propagation in CNN or RNN (to mention some of the topics).  Do you know any book that goes in depth into this theory? I've had a look at a couple (such as Pattern Recognition and Machine Learning by Bishop or Deep Learning by Goodfellow, Bengio and Courville) but still have not found a rigorous one (with exercises would be a plus). Do you have any suggestions? Who is the Community user? I see the  on the user page.  It seems to edit posts sometimes.  What is it? And why has it downvoted over 1800 times? See also: Get value of R, G, B by color In a particular textbook, the work function of a metal (in the context of the photoelectric effect) is defined as:     the minimum amount of energy necessary to remove a free electron from the surface of the metal   This sounds similar to ionisation energy, which is:     the amount of energy required to remove an electron from an atom or molecule in the gaseous state   These two energies are generally different. For instance, Copper has a work function of about 4.7eV but has a higher ionisation energy of about 746kJ mol-1 or 7.7eV.  I've sort of figured it's because the work function deals with free electrons whilst ionisation is done with a valence electron still bound within the atom. Is the difference due to the energy required to overcome the attraction of the positive nucleus? Ok, I must be missing something obvious, but I'm having trouble adding a link to user/%/edit to the main menu.  In the Menu UI, I clicked "add link," set the title to "Account settings," and then was at a loss about what to put for the path.  I know how to generate a link to the account edit page using views, which is what I've always done before, but this time I actually need to add the link to the "Main Menu." I am doing a project where my electronics runs on 5V which I wanted to power from a 7.2v lipo regulated down to that voltage. I'd really like to include the opportunity to charge the lipo without removing it from the project. What kind of circuit/components do I need to do it properly?  Say, would putting a battery charging ic at the battery's terminals in parallel to my system be enough to achieve what I need? I am not a native English speaker, I usually hear “something caught my eye” but never “something caught (both) my eyes”. This seems pretty strange to me.  Cambridge Dictionaries Online provide these examples but without any explanation        (i) to get someone's ​attention:   A ​sudden ​movement ​caught my ​eye.        (ii) to get someone's ​attention, ​especially by ​looking at them:   I ​tried to catch the waiter's ​eye, so we could ​order.        (iii) to be ​attractive or different enough to be ​noticed by someone:   It was the ​unusual ​colour of his ​jacket that ​caught my ​eye.   Why is only one eye ‘caught”? Doesn't something catch our sight? We normally see with both eyes, not with one. Talk to him is what I did Talk to him is what I did.  (this sentence is from )  "Talk" is a verb here that is not in the imperative mood. I suppose, it's in the infinitive form. But then how can it stand alone, without "to"?  What will be if we add "to" to "talk"?  To talk to him is what I did.  If we can do so, then what will difference be between the initial sentence and the new one with "to"?  Maybe, there are some omitted words, after inserting which the sentence will immediately become understandable? I mean, maybe, there is an ellipsis?  Thanks!  To make it clearer:  Upd.1: if we type "bare infinitive" in google, we can't find any sites that could explain the absence from "to" before "talk".  Upd.2: Why can we replace "to talk" with only "talk" in "To talk to him is what I did."  Upd.3: I have my own logic but I don't know whether it's right or not:  1) I think that without an ellipsis "Talk to him is what I did." is to look like "I did talk to him is what I did do."  2) Also I know that we can't use "to" before "read" in "What we must do is read the manual." because in the left part we don't have "to" before "do".  By this logic, we can't use "to" before "talk" in "Talk to him is what I did." because in "what I did do" we don't have "to" before "do".  Am I right or not? Subscribing to questions and comments that don't belong to you On per-site metas, users are given a rank based on meta participation, and this ranking is seen on the default tab of the users page on each per-site meta. How is this participation numerically calculated to give a ranking? Is it by votes? Something else? Are community wiki posts included in this? How to disable Macbook Pro internal display when using external monitors I have a Late 2011 Macbook Pro 13" (running Lion - OS 10.7.4) which I use with a dual external monitor setup. I have two 21" LCDs that I use as external monitors. One uses the built in Mini Display Port on the Macbook Pro and the other is connected via a USB to DVI adapter (Diamond DVILink).  The problem I am having is with the 13" built in display of the Macbook Pro. I would like it to remain closed and unused (I prefer the dual monitors at same resolution), however I cannot seem to "disable" the display in the display preferences applet. So even though the Macbook Pro lid is closed the operating system still makes use of the display, even though the apple logo on the back of the display is unlit. I have tried to move the laptop screen off out of the way in display preferences but I find when I "sleep" my setup that any applications that remain open move to the laptop screen. This makes it difficult to locate the application windows when resuming from sleep.    Does anyone know of a way to disable the laptop built in display so it is not seen by the OS when external monitors are being used? Logical explanation why exponentiation operation is not commutative and associative Considering Peano axioms we'll define addition, multiplication and exponentiation operations.  We can then prove that addition and multiplication operations are commutative and associative. The proof for addition operation is pretty straightforward but for for multiplication it a bit more difficult. For example, to prove associativity, we have to prove distributivity first.  Moreover, for the definition itself it is not obvious that commutativity should take place, because the definition is not symmetric.  $a \cdot 0 := 0$  $a \cdot S(b) := a \cdot b + a$  Here $S(b)$ is the "next" function from Peano axioms  This definition is not symmetric with respect to $a$ and $b$, so commutivity is not obvious.  For exponentiation operation neither commutivity nor associativity take place. And I am very curious about the logical explanation why that happens  NOTE: The explanation I am looking for is somehow similar to a Abel–Ruffini theorem which explains WHY there is no an algebraic solution for a general polynomial equation points out that certain key and block lengths were a requirement for the AES submissions:     The candidate algorithm shall be capable of supporting key-block combinations with sizes of 128-128, 192-128, and 256-128 bits.   My question is this; how can having a key length that is greater than the block size enhance security?  If we look at ECB mode for simplicity, when the key length is equal to the block length we have a permutation relationship between the set of all plaintexts and the set of all ciphertexts.  Once you increase the key length beyond that, you start to introduce collisions. In fact, you only introduce collisions from then on don't you? Collisions in the sense that a key will create the same ciphertext-plantext relationship as another key.  This would lead me to believe that only part of the key-space is unique, and only that part of key-space needs to be brute-forced?  I know that I am clearly incorrect, I just don't understand why. What is the best way to vertically center the content of a div when the height of the content is variable.  In my particular case, the height of the container div is fixed, but it would be great if there were a solution that would work in cases where the container has a variable height as well. Also, I would love a solution with no, or very little use of CSS hacks and/or non-semantic markup. What would be the easiest way to UV map a complex object? I'm attempting to make a texture for a model i've been working on, so i've been trying to get a decent UV map, However whenever I do it usually ends up either very distorted or a lot of unrecognizable pieces or several different UV maps. What are some easier ways of unwrapping/UV Mapping?