Temporary Tables | Linqer

Temporary Tables

Linqer supports Temporary Tables conversion.

For example, the SQL below

declare @Cities TABLE (City varchar(40), Country varchar(10))

insert into @Cities(City,Country) values('London','UK')

insert into @Cities(City,Country) values('Seattle','USA')

SELECT C.*, E.FirstName, E.LastName FROM Employees E JOIN @Cities C ON E.City = C.City

can be converted to LINQ

from E in db.Employees.ToList()

join C in Cities on E.City equals C.City

select new {

City = C.City,

Country = C.Country,




Linqer also provides temporary table definition in the LINQ Classes window.

public class Cities_record


public string City;

public string Country;


public class Cities_table : List<Cities_record>



Data for this temporary table is provided in LINQ Code window

Cities_table Cities = new Cities_table();

Cities_record iCities = new Cities_record


City = "London",

Country = "UK"



iCities = new Cities_record


City = "Seattle",

Country = "USA"