SQL #36

We used Entity Framework in Data-base-first strategy in order to practice LINQ to DB using more complicated commands. we updated the database tables using Entity Model methods (without using SQL queries!). we saw a fast way to print an object using JsonConverter (instead of overriding ToString method), from the Newtonsoft library. then we explored NoSQL using Google’s Firebase free cloud storage. we connected to the Firebase using FireSharp library (nugget) and retrieved data from the FireBase using a C# program.

More topics covered:

• LINQ join command
• Methods in LINQ which can only be written in method syntax
• In order to use EF to add row – table must have a PK
• JSON object serialization
• Firebase console (+db creation)
• FireSharp installation
• Retrieving our Firebase DB URL (for the C# program)
• Retrieving our Firebase secret  (for the C# program)

Links:

• • Good site to learn LINQ commands
  • Newtonsoft link
  • Demo code: Using JSON convert instead of ToString
  • Demo code: more complicated LINQ in EF
  • Firebase – get started link
  • Demo code: Firebase + FireSharp
  • Lesson Summary Video!
  • Homework! (Entity-Framework + Firebase assignment)
  • Topics for the test!