Simple.Data is a lightweight framework that uses the dynamic features of .NET 4 to provide an expressive, ORM-ish way of accessing and manipulating data without any of the code pre-generation and boilerplate required by other frameworks. In this section, we see why and how to get started with Simple.Data. What is Simple.Data? Simple.Data is a …
Insert The Insert method allows the insertion of data into your database. Simple.Data defines a number of commands for the modification of data in a data store. Insert is used to add new data. The return value of an Insert method is a single row of data that has just been inserted. You can insert using two …
Simple.Data requires Beyond that it has no dependencies outside of the BCL other than those within its own sphere. Your project must include references to The diagram above shows all the currently available adaptors and providers and their dependencies.
Simple.Data defines a number of commands for retrieving data from a data store. These can then be daisychained in a LINQ-like fashion with further methods to modify the basic query. For example, the Select method allows the selection of columns to be returned from a data store rather than having all columns retrieved. Select By …
Simple.Data defines a number of commands for retrieving data from a data store. These can then be daisy-chained in a LINQ-like fashion with further methods to modify the basic query. For example, the Join, On, and OuterJoin commands allow you to join two or more tables together in a query and access the contents of …
One of the great features of Simple.Data is that it interprets method and property names at runtime and maps them to your underlying data-store using the convention-based approach. It also allows you to identify schema, table and column names using an indexer syntax. The ‘Fluid’ Way The convention is as follows. So, for example, Albums.GenreId will match …
