| 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() |
![[http]](/imgs/http.png)
Documentation/JPA
