> For the complete documentation index, see [llms.txt](https://wiki.owain.codes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://wiki.owain.codes/coding/umbraco/fluent-sql.md).

# Fluent SQL

```
 using Umbraco.Core.Persistence;
 
 using (var scope = _scopeProvider.CreateScope())
            {
                var sql = scope.SqlContext.Sql().Select("Keyword, Definition").From<GlossaryItem>()
                    .Where<GlossaryItem>(g => g.Language == culture);
                
                var glossaryDefinitions = scope.Database.Query<GlossaryItem>(sql);
                return glossaryDefinitions;
            }
```