title: C# entity framework using LINQ
body: <p>I have a job interview tomorrow and they stated that i have an exam about "C# development using entity framework and LINQ".</p>
  
  <p>For me, entity framework and LINQ are two new approaches. I already know to build C# application where i'd connect the app to a SQLServer database, using the normal connection strings and SQL syntax.</p>
  
  <p>When researching about Entity framework, as a start i learned that i can use the SQLServer object explorer, and create a local database easily from visual studio, then add an OLE.net entity model and perform changes easily.
  As an example, you can see the following code below used to insert a student in a student list.</p>
  
  <pre><code>  using (SchoolEntities1 context = new SchoolEntities1())
              {
                  StudentList sl = new StudentList
                  {
                      Name = tb_Name.Text,
                      Gender = cb_Gender.Text,
                      Grade = Convert.ToInt32(tb_Grade.Text)
                  };
                  context.StudentLists.Add(sl);
                  context.SaveChanges();
  
              }
  </code></pre>
  
  <p>Is this the basic function of entity framework? Should i study anything else that might be useful (other than database manipulation INSERT/UPDATE/DELETE/SELECT)?</p>
  
  <p>Additionally for the LINQ, when researching about it, i see different types of coding as an example, is the definition of student list in the code above a LINQ function? Do i have to use lambda expressions in my codes? </p>
  
  <p>Any links that can help me in  this small time frame would be appreciated.</p>
  
  <p>Thanks.</p>