== Microsoft Entity Framework 과의 비교표 ==
|| SQL || EF 4.0 || Play JPA ||
|| N/A || IQueryable<T> || JPAQuery ||
||SELECT * FROM TableName||.ToList() *||.findAll()||
||SELECT * FROM TableName WHERE Name = 'FullName'||.Where(m => m.Name == "FullName")||.find("byName", "FullName")||
||SELECT * FROM TableName WHERE Name LIKE '%MiddleName%'||.Where(m => m.Name.Contains("MiddleName"))||.find("byNameLike", "%MiddleName%")||
||SELECT * FROM TableName WHERE Name LIKE 'MiddleName%'||.Where(m => m.Name.StartsWith("MiddleName"))||.find("byNameLike", "MiddleName%")||
||SELECT * FROM TableName WHERE Name LIKE '%MiddleName'||.Where(m => m.Name.EndsWith("MiddleName"))||.find("byNameLike", "%MiddleName")||
||SELECT * FROM TableName WHERE Name IS NULL||.Where(m => m.Name == null)||.find("byNameIsNull")||
||SELECT * FROM TableName LIMIT 0, 100||.Take(100)||.fetch(100)||
||SELECT * FROM TableName LIMIT 50, 50||.Skip(50).Take(50)||.from(50).fetch(50)||
||SELECT * FROM TableName LIMIT 0, 10||.First()||.first()||
|| N/A ||.Single()|| N/A ||
||SELECT COUNT(*) FROM TableName||.Count()||.count()||

* ToList()는 엄밀히 말해 전체 내용을 가져오는 함수는 아니지만, 대응되는 EF 메서드가 없어 삽입했다.

참고 : [http://www.playframework.org/documentation/1.2.3/jpa Documentation/JPA]