smithsson68@gmail.com
Jun 9, 2010
  10208
(2 votes)

Best (and fastest) ways to load items from the Dynamic Data Store

There are essentially 4 ways to load items from the Dynamic Data Store, depending upon what information you have and what you want back in response. Below I am going to detail the methods in (probable) speed order. Note the speed order depends how many items are fetched from the store.

Load

Usage Scenario: Load a single item using its id.

If you have the Identity of an item (or at least it’s Guid part) then this should be by far the fastest way to load a single item.

Example:

Identity id = ObtainId();
DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    MyType obj = store.Load<MyType>(id);
}

If the item is already in the DDS cache then then no database hit is required at all.

Find

Usage Scenario: Load one or more items that directly match one or more name/value pairs, without paging.

Example 1: Single match criteria

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.Find<MyType>("MyIntProperty", 34);
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database. This is faster than using Linq because expressions are not used and a direct SQL statement can be generated and executed.

Example 2: Multi match criteria

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.Find<MyType>
    (
        new Dictionary<string, object>()
        {                    
            {"MyIntProperty", 34},
            {"MyStringProperty", "SomeValue"}
        }
    );
}

Linq (Items)

Usage Scenario: Load one or more items with complex parameter matching and paging. Items can also be projected into new types.

Example:

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    var query = from item in store.Items<MyType>()
                where item.MyIntProperty > 33 &&
                item.MyStringProperty.Contains("omeval")
                select item;

    IEnumerable<MyType> items = query.Skip(100).Take(25).ToList();
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database.

LoadAll

Usage Scenario: Load all items from a store without paging

Example:

DynamicDataStore store = DynamicDataStoreFactory.Instance.GetStore(typeof(MyType));

if (store != null)
{
    IEnumerable<MyType> items = store.LoadAll<MyType>();
}

The ids of the matching items will be read from the database and then each item either read from the DDS cache or from the database. If all items are required from a store then this should be marginally faster than using the Linq (Items) methods as LoadAll does not use expressions and a direct SQL statement can be generated and executed.

For loading items back as PropertyBag or types other than the type that was saved see my blog post about Data Container Indifference

Feedback and comments are as always very welcome.

Jun 09, 2010

Comments

Sep 21, 2010 10:33 AM

Very nice to see the different methods.
Is there a way to see all the different datastores that exists?

If you don't want to hardcode the property names like this
store.Find("MyIntProperty", 34);
you could use
store.Find(MembersOf(s=>s.MyIntProperty), 34);

public static class MembersOf
{
public static string GetName(Expression> expr)
{
var node = expr.Body as MemberExpression;
if (object.ReferenceEquals(null, node))
throw new InvalidOperationException("Expression must be of member access");
return node.Member.Name;
}
}

/ Anders Hattestad

Sep 21, 2010 10:33 AM

MembersOf.GetName(s=>s.MyIntProperty)
/ Anders Hattestad

Frederik Vig
Frederik Vig Sep 21, 2010 10:33 AM

@Anders: EPiServer.Data.Dynamic.StoreDefinition.GetAll();

Please login to comment.
Latest blogs
Preview multiple Visitor Groups directly while browsing your Optimizely site

Visitor groups are great - it's an easy way to add personalization towards market segments to your site. But it does come with it's own set of...

Allan Thraen | Sep 26, 2022 | Syndicated blog

The Report Center is finally back in Optimizely CMS 12

With Episerver.CMS.UI 12.12.0 the Report Center is finally re-introduced in the core product.

Tomas Hensrud Gulla | Sep 26, 2022 | Syndicated blog

Dynamic Route in ASP.NET Core When MapDynamicControllerRoute Does Not Work

Background Creating one of the add-on for Optimizely I had to deal with challenge to register dynamically route for the API controller. Dynamic rou...

valdis | Sep 25, 2022 | Syndicated blog

404 Error on Static Assets Within an Optimizely plugin

Background With the move to CMS 12 and .NET 5/6, developers are now able to build Plugins and Extensions using Razor Class Libraries (RCL).  These...

Mark Stott | Sep 23, 2022