linq orderby collection property

 IQueryable<Parent> data = context.Parents.OrderBy(p=>p.Children.OrderBy(chi => chi.Name).FirstOrDefault());

How to execute sql queries in workbench mysql ?

 If you are from MS SQL background and first time working with MySql , you may be struggling for finding the shortcut key to execute the sql query in workbench. 

Here is the short cut to execute the SQL query in workbench MySql. 

Default key mapping

1. Execute (All or Selection) -> Ctrl + Shift + Enter.
2. Execute Current Statement -> Ctrl + Enter.

How to assign property value while initializing class in typescript

 While creating new object you want to set the value of few fields of class , then you can use following feature of typescript to do that : 

class Person {
    public name: string = "default"
    public address: string = "default"
    public age: number = 0;

    public constructor(init?:Partial<Person>) {
        Object.assign(this, init);
    }
}

let persons = [
    new Person(),
    new Person({}),
    new Person({name:"John"}),
    new Person({address:"Earth"}),    
    new Person({age:20, address:"Earth", name:"John"}),
];

How to make sure application always run with admin access

 Most of the time it happen with programmer , that they forget to run the application (Visual Studio/VS Code or any other IDE) with admin access. Because of that in result they face weird errors. So instead of every time facing same issue again and again, we can set the application permission in such way that its always run with admin access. 

Here are the steps which you can use to make sure your application always run with admin access. 

how to make sure application always run with admin access

1. Open Start.
2. Search for the app that you want to run elevated.
3. Right-click the top result, and select Open file location. ...
4. Right-click the app shortcut and select Properties.
5. Click on the Shortcut tab.
6. Click the Advanced button.
7. Check the Run as administrator option.

How to find the angular component name ?

 

Use ng.probe($0).componentInstance

You can select a component using the Element Selector from the Elements Tab. And then go to the Console Tab, and type in:

ng.probe($0).componentInstance

Where to find the files after ng build in angular

Once you run the ng build --prod for deployment build and you are wondering after successfully from where to copy files to deployment. 

You can check path on following setting where its mentioned in angular.json file. 

"outDir": "./location/toYour/dist"

How to remove all elements from JavaScript Array ?

 In case you have an array in JavaScript and you want to remove all elements from that array , there are couple of ways by which you can remove all elements from your array. 

#1 

Arr = [];

#2 




 Arr.length = 0

#3 

 

 Arr.splice(0,Arr.length)

#4 

  

while(Arr.length > 0) {
    Arr.pop();
}