Transmit Security interview question

1. How does LINQ in C# translate queries into SQL and handle the execution against the database?