How would one fetch an entity using SQL like this for example

SELECT tblSomething.* from tblSomething WHERE tblSomething.Somefield = "value"

i.e. not using primary key or constraint

Thanks

In adapter use adapter.FetchNewEntity() and in selfservicing, fetch the entity in an entity collection.