With EF or LINQ to SQL:

    var item = db.Items.OrderByDescending(i =&gt; i.Value).FirstOrDefault();

With LINQ to Objects I suggest to use [morelinq][1] extension `MaxBy` (get morelinq from nuget):

    var item = items.MaxBy(i =&gt; i.Value);


  [1]: https://github.com/morelinq/MoreLINQ

I&#39;m not clear how jackson deals with capitalization in mapping fields. If anyone could help I&#39;d appreciate it. 


    {&quot;user&quot;:{&quot;username&quot;:&quot;user@host.com&quot;,&quot;password&quot;:&quot;pwd&quot;,&quot;sendercompid&quot;:&quot;COMPID&quot;,&quot;service&quot;:{&quot;host&quot;:&quot;address&quot;,&quot;port&quot;:6666,&quot;service&quot;:&quot;S1&quot;,&quot;serviceAsString&quot;:&quot;s1&quot;}},&quot;MDReqID&quot;:&quot;ghost30022&quot;,&quot;NoRelatedSym&quot;:1,&quot;Symbol&quot;:[&quot;GOOG&quot;],&quot;MarketDepth&quot;:&quot;0&quot;,&quot;NoMDEntryTypes&quot;:3,&quot;MDEntryType&quot;:[&quot;0&quot;,&quot;1&quot;,&quot;2&quot;],&quot;SubscriptionRequestType&quot;:&quot;1&quot;,&quot;AggregatedBook&quot;:&quot;N&quot;}:

Above is my json, below is my exception...

    com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: Unrecognized field &quot;MDReqID&quot; (class com.myco.qa.fixrest.MarketDataRequest), not marked as ignorable (10 known properties: , &quot;mdreqID&quot;, &quot;marketDepth&quot;, &quot;user&quot;, &quot;subscriptionRequestType&quot;, &quot;aggregatedBook&quot;, &quot;mdentryType&quot;, &quot;symbol&quot;, &quot;mdupdateType&quot;, &quot;noRelatedSym&quot;, &quot;noMDEntryTypes&quot;])

Above is my exception, below is my class...

    public class MarketDataRequest {
        private User user;
        private String MDReqID;
        private char SubscriptionRequestType;
        private int MarketDepth;
        private int MDUpdateType;
        private char AggregatedBook;
        private int NoMDEntryTypes;
        private ArrayList&lt;Character&gt; MDEntryType;
        private int NoRelatedSym;
        private ArrayList&lt;String&gt; Symbol;
    
        public User getUser() {
            return user;
        }
    
        public void setUser(User user) {
            this.user = user;
        }
    
        public String getMDReqID() {
            return MDReqID;
        }
    
        public void setMDReqID(String MDReqID) {
            this.MDReqID = MDReqID;
        }
    
        public char getSubscriptionRequestType() {
            return SubscriptionRequestType;
        }
    
        public void setSubscriptionRequestType(char subscriptionRequestType) {
            SubscriptionRequestType = subscriptionRequestType;
        }

... et cetera




Jackson JSON field mapping capitalization?

When I am trying to push to my remote git repository, but it is taking forever and nothing happens. I waited for so long, but push is never getting finished. My OS is Ubuntu 12.10. Thank you.

Git push takes forever

Have a look at the below table:

    Item          Value
    A                10
    b                50
    c                90

I want to find the item with `maximum value`. I can get that by using `group by` or `orderding`, but somehow I have a feeling there should be a more direct way. Am I right?

How to find item with max value using linq?

Have a look at the below table:
<pre><code class="hljs language-css">Item Value
A 10
b 50
c 90
</code></pre>
I want to find the item with <code>maximum value</code>. I can get that by using <code>group by</code> or <code>orderding</code>, but somehow I have a feeling there should be a more direct way. Am I right?

With a list you can do:

    list.AddRange(otherCollection);

There is no add range method in a `HashSet`.
What is the best way to add another `ICollection` to a `HashSet`?

Is there an AddRange equivalent for a HashSet in C#

I try upload a file to an FTP-server with C#. The file is uploaded but with zero bytes.

    private void button2_Click(object sender, EventArgs e)
    {
        var dirPath = @&quot;C:/Documents and Settings/sander.GD/Bureaublad/test/&quot;;
    
        ftp ftpClient = new ftp(&quot;ftp://example.com/&quot;, &quot;username&quot;, &quot;password&quot;);
    
        string[] files = Directory.GetFiles(dirPath,&quot;*.*&quot;);
        
        var uploadPath = &quot;/httpdocs/album&quot;;
    
        foreach (string file in files)
        {
            ftpClient.createDirectory(&quot;/test&quot;);
    
            ftpClient.upload(uploadPath + &quot;/&quot; + Path.GetFileName(file), file);
        }
    
        if (string.IsNullOrEmpty(txtnaam.Text))
        {
            MessageBox.Show(&quot;Gelieve uw naam in te geven !&quot;);
        }
    }

Upload file to FTP using C#

I have a list with some identifiers like this:

    List&lt;long&gt; docIds = new List&lt;long&gt;() { 6, 1, 4, 7, 2 };

Morover, I have another list of `&lt;T&gt;` items, which are represented by the ids described above.

    List&lt;T&gt; docs = GetDocsFromDb(...)

I need to keep the same order in both collections, so that the items in `List&lt;T&gt;` must be in the same position than in the first one (due to search engine scoring reasons). And this process cannot be done in the `GetDocsFromDb()` function. 

If necessary, it&#39;s possible to change the second list into some other structure (`Dictionary&lt;long, T&gt;` for example), but I&#39;d prefer not to change it.

Is there any simple and efficient way to do this &quot;ordenation depending on some IDs&quot; with LINQ?

Sort a list from another list IDs

I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not  use the same reference with MS VS 2012.

    var app = new Microsoft.Office.Interop.Excel.Application();
    Workbooks wbs = app.Workbooks;

How to reference Microsoft.Office.Interop.Excel dll?

Within C# application code, I would like to create and then interact with one or more SQLite databases.

How do I initialize a new SQLite database file and open it for reading and writing?

Following the database&#39;s creation, how do I execute a DDL statement to create a table?

Create SQLite Database and table

I am trying to get something like the following to work:

    _dbmsParentSections = FactoryTools.Factory.PdfSections
                            .Include(x =&gt; x.Children.OrderBy(y =&gt; y.Order).ToList())
                            .Include(x =&gt; x.Hint).Include(x =&gt; x.Fields)
                            .Where(x =&gt; x.FormId == FormId &amp;&amp; x.Parent == null)
                            .OrderBy(o =&gt; o.Order)
                            .ToList();

The part that causes the exception is:

    .Include(x =&gt; x.Children.OrderBy(y =&gt; y.Order).ToList())


**EDIT:**

 Upon further observation,

    _dbmsParentSections.ForEach(x =&gt; x.Children = x.Children.OrderBy(y =&gt; y.Order).ToList());


did the job for me (after the initial `Factory` call and without the `Children.OrderBy`).

Entity Framework (.NET Full Framework) Ordering Includes

The [accepted answer to question &quot;Why does this Parallel.ForEach code freeze the program up?&quot;][1] advises to substitute the List usage by [ConcurrentBag][2] in a WPF application.  

I&#39;d like to understand whether a [BlockingCollection&lt;T&gt;][3] can be used in this case instead?   


  [1]: https://stackoverflow.com/a/8365614/2031316
  [2]: http://msdn.microsoft.com/en-us/library/dd381779.aspx
  [3]: http://msdn.microsoft.com/en-us/library/dd267312%28v=vs.100%29.aspx

When to use BlockingCollection and when ConcurrentBag instead of List&lt;T&gt;?

This may seem silly, but all the examples I&#39;ve found for using `Except` in linq use two lists or arrays of only strings or integers and filters them based on the matches, for example:

    var excludes = users.Except(matches);

I want to use exclude to keep my code short and simple, but can&#39;t seem to find out how to do the following:

    class AppMeta
    {
        public int Id { get; set; }
    }
    
    var excludedAppIds = new List&lt;int&gt; {2, 3, 5, 6};
    var unfilteredApps = new List&lt;AppMeta&gt;
                             {
                               new AppMeta {Id = 1},
                               new AppMeta {Id = 2},
                               new AppMeta {Id = 3},
                               new AppMeta {Id = 4},
                               new AppMeta {Id = 5}
                             }

How do I get a list of `AppMeta` back that filters on `excludedAppIds`?


Filter Linq EXCEPT on properties

I am trying to select stores using a lambda function and converting the result to a SelectListItem so I can render it.  However it is throwing a &quot;**Type of Expression in Select Clause is Incorrect**&quot; error:

    IEnumerable&lt;SelectListItem&gt; stores =
        from store in database.Stores
        where store.CompanyID == curCompany.ID
        select (s =&gt; new SelectListItem { Value = s.ID, Text = s.Name} );
    ViewBag.storeSelector = stores;
What am I doing wrong?

EDIT:

Also, how do I convert Int to String in this situation?  The following does not work:

    select (s =&gt; new SelectListItem { Value = s.ID.ToString(), Text = s.Name} );
    select (s =&gt; new SelectListItem { Value = s.ID + &quot;&quot;, Text = s.Name} );

EDIT 2:

Figure out the Int to String conversion.  It is so typical of Microsoft to forget to include an int2string conversion function.  Here is the actual workaround everyone is using, with fully working syntax:

    select new SelectListItem { Value = SqlFunctions.StringConvert((double)store.ID), Text = store.Name };

To call this situation absurd is an understatement.

How to use Lambda in LINQ select statement

How do I find all rows in a pandas DataFrame which have the max value for `count` column, after grouping by `[&#39;Sp&#39;,&#39;Mt&#39;]` columns?

**Example 1:** the following DataFrame, which I group by `[&#39;Sp&#39;,&#39;Mt&#39;]`:

       Sp   Mt Value   count
    0  MM1  S1   a     **3**
    1  MM1  S1   n       2
    2  MM1  S3   cb    **5**
    3  MM2  S3   mk    **8**
    4  MM2  S4   bg    **10**
    5  MM2  S4   dgd     1
    6  MM4  S2   rd      2
    7  MM4  S2   cb      2
    8  MM4  S2   uyi   **7**

Expected output: get the result rows whose count is max in each group, like:

    0  MM1  S1   a      **3**
    2  MM1  S3   cb     **5**
    3  MM2  S3   mk     **8**
    4  MM2  S4   bg     **10** 
    8  MM4  S2   uyi    **7**


**Example 2:** this DataFrame, which I group by `[&#39;Sp&#39;,&#39;Mt&#39;]`: 

	   Sp   Mt   Value  count
	4  MM2  S4   bg     10
	5  MM2  S4   dgd    1
	6  MM4  S2   rd     2
	7  MM4  S2   cb     8
	8  MM4  S2   uyi    8

For the above example, I want to get **all** the rows where `count` equals max, in each group e.g:

	MM2  S4   bg     10
	MM4  S2   cb     8
	MM4  S2   uyi    8

Get the row(s) which have the max value in groups using groupby

![Structure of data;][1]


  [1]: http://i.stack.imgur.com/a34it.png

Using Python Pandas I am trying to find the ```Country``` &amp; ```Place``` with the maximum value.

This returns the maximum value:

    data.groupby([&#39;Country&#39;,&#39;Place&#39;])[&#39;Value&#39;].max()

But how do I get the corresponding ```Country``` and ```Place``` name?

Find maximum value of a column and return the corresponding row values using Pandas

I have been given a CSV file with more than the MAX Excel can handle, and I really need to be able to see all the data. I understand and have tried the method of &quot;splitting&quot; it, but it doesnt work.

Some background: The CSV file is an Excel CSV file, and the person who gave the file has said there are about `2m` rows of data.

When I import it into Excel, I get data up to row `1,048,576`, then re-import it in a new tab starting at row `1,048,577` in the data, but it only gives me one row, and I know for a fact that there should be more *(not only because of the fact that &quot;the person&quot; said there are more than 2 million, but because of the information in the last few sets of rows)*

I thought that maybe the reason for this happening is because I have been provided the CSV file as an Excel CSV file, and so all the information past `1,048,576` is lost (?). 

DO I need to ask for a file in an SQL database format?


Excel CSV. file with more than 1,048,576 rows of data

I&#39;m trying to find a function that returns *all* occurrences of the maximum in a given list.

 [`numpy.argmax`][1] however only returns the first occurrence that it finds. For instance:

    from numpy import argmax

    list = [7, 6, 5, 7, 6, 7, 6, 6, 6, 4, 5, 6]
    winner = argmax(list)

    print winner

gives only index `0`. But I want it to give all indices: `0, 3, 5`.



  [1]: http://docs.scipy.org/doc/numpy/reference/generated/numpy.argmax.html

How to make numpy.argmax return all occurrences of the maximum?

Here&#39;s what I&#39;m trying to do. Let&#39;s say I have this table t:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    2      | 18 | 2012-05-19  | y
    3      | 18 | 2012-08-09  | z
    4      | 19 | 2009-06-01  | a
    5      | 19 | 2011-04-03  | b
    6      | 19 | 2011-10-25  | c
    7      | 19 | 2012-08-09  | d

For each id, I want to select the row containing the minimum record_date. So I&#39;d get:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    4      | 19 | 2009-06-01  | a

The only solutions I&#39;ve seen to this problem assume that all record_date entries are distinct, but that is not this case in my data. Using a subquery and an inner join with two conditions would give me duplicate rows for some ids, which I don&#39;t want:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    5      | 19 | 2011-04-03  | b
    4      | 19 | 2009-06-01  | a

Content Type	Original Author	Original Content on Stackoverflow
Question	user1784622	View Question on Stackoverflow
Solution 1 - C#	Sergey Berezovskiy	View Answer on Stackoverflow

How to find item with max value using linq?

C# Problem Overview

C# Solutions

Solution 1 - C#

Git push takes forever

Jackson JSON field mapping capitalization?

Attributions