Developer(s) EntitySpaces, LLC Operating system | Written in C# Platform .NET 3.5+ and Mono | |
Stable release EntitySpaces 2012.1.0930.0 / 4 October 2012 Type Object-relational mapping |
EntitySpaces is an object-relational mapping tool, whose architecture can be used when writing an ASP.NET, .NET Framework or .NET Compact Framework application. The architecture is provider independent, allowing developers to run the same binary code against any of the supported databases. EntitySpaces works with both C# and VB.NET and uses no reflection and no XML files.
Contents
- EntitySpaces LLC
- Doodads
- Providers Available
- Examples
- Querying a Collection
- Saving a Collection
- Adding new records through a Collection
- Deleting a record through a Collection
- References
Although EntitySpaces targets both ASP.NET and Windows.Forms projects, DotNetNuke module developers can use the architecture as an alternative to the DotNetNuke DAL. Many of the features listed below, including important ones like transactions, are not available when using the DotNetNuke DAL API.
EntitySpaces, LLC
On January 18, 2006 a filing was made for the formation of "EntitySpaces, LLC", a limited liability company. On January 23, 2006 EntitySpaces, LLC officially became a legal entity. In February, EntitySpaces, LLC put together a commercial offering for the EntitySpaces .NET architecture.
On September 21, 2012, EntitySpaces announced they would dissolve on December 31, 2012 and their products would transition to open source.
Doodads
The dOOdads .NET Architecture was created by Mike Griffin and, in many ways, is the progenitor of EntitySpaces. During the dOOdads architecture development and evolution, a lot was learned from the community, much of which has made its way into EntitySpaces.
The dOOdads architecture is written natively in both C# and VB.NET. The dOOdads .NET architecture also comes with MyGeneration templates that generate native C# or VB.NET dOOdad classes.
The EntitySpaces binaries are written in C#. Templates are available to generate both C# and VB.NET concrete and abstract classes, so EntitySpaces is fully supported for both languages, but native VB.NET binaries are not provided.
Providers Available
Examples
The following are examples of using EntitySpaces with the Northwind Database.
Querying a Collection
This sample loads all Employees whose last name starts with “Smi”.
Saving a Collection
Here the Employees are being transferred to Indianapolis. You never call Save on the single entity when it lives in a collection. Save will commit all modified, added, and deleted rows.
Adding new records through a Collection
Here two new Employees are being added and saved.
Deleting a record through a Collection
This example demonstrates the use of FindByPrimaryKey to locate a particular Employee in the collection, then marks it as deleted, and finally saves the collection.
If you need to delete all of the records from a table, you use the MarkAllAsDeleted method as follows: