- General Shortcuts Ctrl+Shift+P/F1
Show Command Palette
Ctrl+P
Quick Open
Ctrl+Shift+N
| /* | |
| ORM (Object-Relational Mapping) allows us to have a framework | |
| for storing objects within relational databases and translating between | |
| DATABASE-CODE communication. | |
| What is ORM? | |
| 1. Object relational mapping is a technique for storing, | |
| retrieving, updating and deleting (CRUD) from | |
| an object-oriented program in a relational database. | |
| 2. Utilization of "data layer" to manage translation between the OO and relational |
| public interface IClass | |
| { | |
| void TestMethod(); | |
| } | |
| public class Class : IClass | |
| { | |
| void TestMethod() | |
| { | |
| Console.WriteLine("LOL"); |
| private async void Search_Click(object sender, RoutedEventArgs e) | |
| { | |
| ... | |
| // By using Task.Run we can execute code that is not asynchronous-friendly | |
| // on different thread so it wont block our main UI for example. | |
| await Task.Run(() => | |
| { | |
| var lines = File.ReadAllLines(@"path"); |
| SELECT a.Id, COUNT(b.Title) AS BookCount FROM BooksDB.dbo.Books AS b JOIN BooksDB.dbo.Authors AS a ON b.AuthorId = a.Id GROUP BY a.Id | |
| UPDATE BooksDB.dbo.Fun SET Value = (SELECT COUNT(b.Title) AS BookCount FROM BooksDB.dbo.Books AS b JOIN BooksDB.dbo.Authors AS a ON b.AuthorId = a.Id GROUP BY a.Id) | |
| ID AUTORA LICZBA_KSIĄŻEK (ZLICZONA W QUERY) AS LQ LICZBA_KSIĄŻEK (ZAPISANA W TABELI) AS LT | |
| ------------------------------------------------- | |
| JOIN STATS ON LT.ID = LQ.ID | |
| --------------------------------------------- |
| Let's assume that you have branch named "routing” and you are working on it. | |
| At first, make sure your git fetch and git pull master (or like previously in our team table-view-of-events) | |
| Then you need to create new branch based on master (or like previously in our team table-view-of-events) | |
| You can name it like for example routing-rebase1 | |
| It will be on your local machine, no need to push it to ADO | |
| Then, you need git checkout routing-rebase1 | |
| /* | |
| List of Angular elements: | |
| a) component | |
| b) directive | |
| c) module | |
| d) pipe | |
| e) service | |
| - interceptors | |
| - resolvers | |
| f) guard |
| Strangler | |
| Bridge | |
| Factory | |
| Abstract Factory | |
| Mediator | |
| Adapter | |
| Decorator | |
| Null object | |
| Builder | |
| Prototype |
Show Command Palette
Ctrl+P
Quick Open
Ctrl+Shift+N
| // FASTER THAN INTERFACES, BECAUSE EVERYTHING IS IN ONE PLACE! | |
| public abstract class AbstractWorker | |
| { | |
| // CONST, FIELDS, PROPERTIES ALLOWED! | |
| const int salaryMultiplier = 1; | |
| protected int Salary { get; set; } | |
| private IWorker _worker; | |
| public constructor(IWorker worker, int baseSalary) |