C#

SELECT CustomerID,FirstName,LastName,PhoneNo,Email and count(*) as OrderCount
FROM Customers 
INNER JOIN Orders ON Customers .CustomerID = Orders .CustomerID
GROUP BY CustomerID,FirstName,LastName,PhoneNo,Email
WHERE CustomerID=101

var data = (from c in db.customers 
              join o in db.orders 
              on c.CustomerID = o.CustomerID into subs
              from sub in subs.DefaultIfEmpty()
              group sub by new { c.CustomerID, c.FirstName,c.LastName,c.PhoneNo,c.Email  } into gr
              select new {
                  gr.Key.CustomerID,
                  gr.Key.FirstName,
                  gr.Key.LastName,
                  gr.Key.PhoneNo,
                  gr.Key.Email,
                  OrderCount = gr.Count(x => x != null)
              }).ToList();

var data = db.Customers
    .Where(c => c.CustomerID == 101)
    .Select(c => new 
    {
        c.CustomerID,
        c.FirstName,
        c.LastName,
        c.PhoneNo,
        c.Email,
        OrderCount = db.Orders.Count(o => o.CustomerID == c.CustomerID)
    })
    .ToList();

Quote:

it does not work.

 
So this code is to run a program that i, we carry inside the project, in that resource folder.

but he is like you and I want him as C # I put it to convert more it does not work

And it's not flush, the broker showed it wrong, I meant program or file 

private static int nextValue = 1;

public PersonalDetail()
   {
   Id = nextValue++;
   }

• Add a static private member variable that holds the last assigned ID
  
• Provide a constructor that increments the last ID and assigns the value to Id
  
• Make the incrementing and copying of the last ID member thread safe (e.g. using Interlocked.Increment)
  
• Make the set method for Id private
  

public class PersonalDetail
{
    public PersonalDetail(string firstName, int age)
    {
        if (IdToInstance.Any(kvp => kvp.Value.FirstName.Equals(firstName)))
        {
            throw new DuplicateNameException();
        }

        FirstName = firstName;
        Age = age;

        IdToInstance.Add(Id++, this);
    }

    public string FirstName { get; set; }
    public int Age { get; set; }

    // static constructor
    static PersonalDetail()
    {
        Id = 1;
        IdToInstance = new Dictionary<int, PersonalDetail>();
    }

    static int Id { set; get; }

    static Dictionary<int, PersonalDetail> IdToInstance { get; }

    public static void Add(params (string name, int age)[] pds)
    {
        foreach (var pd in pds)
        {
            new PersonalDetail(pd.name, pd.age);
        }
    }

    public static PersonalDetail InstanceFromId(int id)
    {
        PersonalDetail pd = null;

        return IdToInstance.TryGetValue(id, out pd) ? pd : null;
    }
}

/* usage example

// multiple instances created
// using C# 7 tuple syntax
PersonalDetail.Add(
    (name: "Tapan", age: 11), // names optional
    ("Joy", 21),
    ("Madhu", 31)
);


// test index data
var id2 = PersonalDetail.InstanceFromId(2);

// check index function won't crash on bad dara
var idbad = PersonalDetail.InstanceFromId(11);

// force error
PersonalDetail.Add(("Tapan", 200));
*/

Member 13621117 wrote:

how do I download and install a direct program from the site?

So, I have a folder where it contains the files adb.exe, fastboot, logo, recovery ...

I want to know how to direct the commands using this folder.

example: in this folder, you have the file "LOGO.BIN" and need to push to the cell phone using this command "Fastboot flash logo logo.bin"

<pre>
OpenFileDialog openfile = new OpenFileDialog();

            openfile.Filter = "IMG files|*.img";
            openfile.Title = "Open a file..";
            if (openfile.ShowDialog() == DialogResult.OK)
            {
                flashrecoveryTextbox.Text = openfile.FileName;
                Process process = new Process();
                ProcessStartInfo startInfo = new ProcessStartInfo();
                startInfo.WindowStyle = ProcessWindowStyle.Hidden;
                startInfo.CreateNoWindow = true;
                startInfo.UseShellExecute = false;
                startInfo.RedirectStandardOutput = true;
                startInfo.FileName = "fastboot.exe";
                startInfo.Arguments = " flash logo.bin\"" + openfile.FileName + "\"";
                process.StartInfo = startInfo;
                process.Start();
                Console.Text = Console.Text + process.StandardOutput.ReadToEnd();
            }

Member 13621117 wrote:

how do I download and install a direct program from the site?