Old SDK – New SDK Query by OwnerId
Wednesday, June 2, 2010 at 05:39PM The latest update to the MSCRM SDK included a new LINQ provider. In this blog post we are going to compare and contrast querying for data by owner ID using the old and new SDK techniques. If you are new to the LINQ provider then you should read my quick start blog post here first.
For this example let’s assume I want to retrieve accounts where the owner ID is the current user. The following is straight from the CRM SDK and uses the lower level API calls. Keep reading past it and I will use the new LINQ provider to accomplish the same thing plus a little bit.
Guid principalId = user.UserId;
// Create a column set holding the names of the columns to be retrieved.
ColumnSet colsPrincipal = new ColumnSet();
// Set the properties of the column set.
colsPrincipal.Attributes = new string[] { "name", "accountid" };
// Create a ConditionExpression.
ConditionExpression conditionPrincipal = new ConditionExpression();
// Set the ConditionExpressions properties so that the condition is true when the
// ownerid of the account equals the principalId.
conditionPrincipal.AttributeName = "ownerid";
conditionPrincipal.Operator = ConditionOperator.Equal;
conditionPrincipal.Values = new object[1];
conditionPrincipal.Values[0] = principalId;
// Create the FilterExpression.
FilterExpression filterPrincipal = new FilterExpression();
// Set the properties of the FilterExpression.
filterPrincipal.FilterOperator = LogicalOperator.And;
filterPrincipal.Conditions = new ConditionExpression[] { conditionPrincipal };
// Create the QueryExpression.
QueryExpression queryPrincipal = new QueryExpression();
// Set the properties of the QueryExpression.
queryPrincipal.EntityName = EntityName.account.ToString();
queryPrincipal.ColumnSet = colsPrincipal;
queryPrincipal.Criteria = filterPrincipal;
// Create the request object.
RetrieveMultipleRequest retrievePrincipal = new RetrieveMultipleRequest();
// Set the properties of the request object.
retrievePrincipal.Query = queryPrincipal;
Now that we have looked at how we would have done this in the past, let’s look at what is possible using the new LINQ provider. First, you should have already read my other blog post where I talked about how to call Who Am I to get the current user ID here. For this example we startup assuming that has already been accomplished.
To make this a little more interesting, in addition to just retrieving the accounts for the user I also want to retrieve the user’s name and only the first 10 accounts.
The first thing we are going to do is build the LINQ expression that will provide the criteria for our query. The following queries for accounts that have an owner ID matching. It also shapes the results into an anonymous type that only has the properties ID and Name. Pause for a second and compare the following 7 lines, which could really be expressed as 1 line to the code we used above without the LINQ provider.
var principalQuery = from acct in ctx.accounts
where acct.ownerid.Value == currentUserID
select new
{
ID = acct.accountid,
Name = acct.name
};
Remember, the above just defines the LINQ expression it doesn’t cause execution of the query against the CRM server that will happen later when we start to enumerate the results. Next, let’s go get the user information so we can grab the full name of the user.
var userInfo =
ctx.systemusers.Where(u => u.systemuserid == currentUserID).FirstOrDefault();
| If we retrieved a user the output the user name. |
| if (userInfo != null) Console.WriteLine("First 10 Accounts for user " + userInfo.fullname); Next, we are going to enumerate the accounts and print the account name. Notice that we added a Take(10) onto the LINQ query we built earlier. This will cause only the first 10 records to be used. foreach (var acct in principalQuery.Take(10)) Console.WriteLine(" Account Name :" + acct.Name); Hopefully it’s clear from the example the new CRM LINQ provider that’s part of the updated SDK makes it much easier to build queries against the CRM data. |
Reader Comments (137)
The modern replica tag heuer watches
comes housed in a black plastic case with stainless steel lugs at each side. The black
wristband is nicely crafted from leather, and in case you plan on banging your new watch
around a bit, the display is protected by a durable, scratch-resistant mineral crystal
face.
large number ofLVfor discount
As a top luxury consumablelouis vuitton handbags louis vuitton handbags
louis vuitton bags louis vuitton handbags
hight quality louis vuitton louis vuitton handbags
if you want to buy louis vuitton bag louis vuitton handbags
high quality and inexpensivelouis vuitton wallets louis vuitton wallets
new arrive louis vuitton purses louis vuitton wallets
Large numbers oflouis vuitton wallets louis vuitton wallets
------
gucci handbagsgucci handbags
chanel handbagschanel handbags
louis vuitton handbagslouis vuitton handbags
pradafor discount
prada bagsprada bags
prada handbagsprada handbags
prada shoesprada shoes
mens watchesmens watches
buy replica watchesbuy replica watches
guess watchesguess watches
rado watchesrado watches
mengzhilin1008
You'll discover substantial variance on selling price whenever you shop for skeleton hamilton watches replicas depends on the exact quality on the wristwatches as well as the designer. Generally, a special skeleton enjoy with fine quality is about 200 to 300 dollars.
A skeleton enjoy can make an remarkable choice and makes a great gift. With so a lot of to choose from, stylish skeleton wristwatches for both men and women are readily attainable. They are beautiful and particular forms of classic watchmaking that enable the exact "time" to be exposed!replica iwc|
SALE~EDHARDY Ladies Black,White,Blue,Green Shirt Top Rose Pattern XL
please look at the link below:
Ed Hardy
Ed Hardy Clothing
shirts
Ed Hardy Clothes
shoes
swimwear
Although to some it may feel oh-so-far-off, spring is on it's way, and here are the louis vuitton to prove it!
New Christian Louboutin spring shoes are hitting the shelves and they are colorful, whimsical and playful,perfect for a spring or summer wedding looking for a little jolt of fun! and now discount for Gucci,Which are your faves?
weight loss
diet pills
how to lose weight fast
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
lv
discount handbags
louis vuitton bags
louis vuitton blog
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
lv
discount handbags
louis vuitton bags
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
lv
discount handbags
louis vuitton bags
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts
rosetta stone
rosetta stone software
rosetta
chaojimengnan supplier
chaojimengnan
The writer seems to have his homework finished.
100 % agree with the fact.
wholesale gucci clothing provides you the best and cheapest bags. All the products at http://www.gucci-buying.com are 100% high quality, competitive price, free shipping with best and timely service, 100% satisfaction. Big discount for big order. Welcome to make your choose.
I have buyed many products on line.Cool.I found some good sites,whose
pruducts have gained popularity among socialites and celebrities.From
these sites,several of my friends buyed products.The Website including.
ed
hardy ed
street fashion
christian audigier
Ed Hardy Jeans
ed hardy online
ed hardy shirt
ed hardy shirts
Ed Hardy Shoes
Ed Hardy Sunglasses
Ed Hardy Tops
Ed Hardy Hoodies
Ed Hardy Swimwear
Ed Hardy Bags
Ed Hardy Caps
Ed Hardy Belts
pre-owned sweepers. truck craneEvery road sweeper. mobile craneOur engineers and vacuum systems.road sweeper We nced precinct trailer partssweepers available today work glovesfrom such asleather gloves Applied walk behind sweepers, tiffany jewelrycompact sweepers,Christian louboutinprecinct sweepers Herve leger sweepers. hair products of used杭州装饰公司 we Jewelry Findingsoffer wedding bagsa full冷却塔workshop glass beadsand carePVP for your existing
I love the ed hardy clothings from the visual POV. ed hardy clothes created ripples one of the fashion conscious immediately after the ed hardy was launched. I like the ed hardy clothing. ed hardy is one
kind of the most famous brands. ed hardy clothing displays the brilliant work of Don ed hardy. He's
agifted painter, printmaker and tattoo artist. ed hardy offerings include
Ed Hardy
Ed Hardy Clothing
Ed Hardy Bikini
shirts
Ed Hardy Clothes
shoes
swimwear
ed hardy.clothes is merely 4 yrs . old and was launched by Audigier in 2004. There were many Hollywood stars
who wear his ed hardy clothing.
<A href=" http://www.buycheapchina.com/"> ed hardy clothing wholesale</A>
<A href=" http://www.buycheapchina.com/"> Cheap louis vuitton</A>
<A href=" http://www.buycheapchina.com/"> Discount prada shoes</A>
<A href=" http://www.buycheapchina.com/"> new polo relph lauren</A>
<A href=" http://www.buycheapchina.com/">cheap jordan sneakers</A>
<A href=" http://www.buycheapchina.com/">Replica louis vuitton</A>
A typical look at does reflects your wealth, status and ability..replica hermes|
A typical look at does reflects your wealth, status and ability..replica hermes|
New black and white on red shoes christian louboutin shoes - Louboutin shoes christian louboutin shoes sale Shop the 2010 gucci Fall Winter Collection Online Today Looking for gucci bags gucci products 80% OFF Authentic gucci handbags Free Ship We Buy cartier watches Earn Top cartier Dollar for Your Watch Breitling breitling watches fashion breitling watch louis vuitton handbags denim leather bags, not price,LV monogram canvas bag, priced at 715 U.S. dollars lv of stylish lv handbags louis vuitton sale The new autumn wallet louis vuitton wallet elegant plain LV Omega (omega watches) List Constellation Series Automatic Mechanical Men
christian louboutin
buy christian louboutin
buying christian louboutin
cheap christian louboutin
cheaper christian louboutin
cheapest christian louboutin
discount christian louboutin
christian louboutin discounted
christian louboutin pumps
christian louboutin boots
christian louboutin sale
christian louboutin sandals
christian louboutin shoes
christian louboutin shop
christian louboutin sling back
christian louboutin wedding
christian louboutin wedges
christian louboutin bridal
christian louboutin orsay
christian louboutin paquita
christian louboutin peep
christian louboutin petal
christian louboutin pigalle
christian louboutin pronounce
buy chanel
cheap chanel
cheapest chanel
discount chanel
chanel sale
chanel bags
chanel handbags
chanel purse
chanel belt
chanel wallet
chanel shop
chanel store
chanel designer
chanel messenger
chanel hobo
chanel travel
chanel shoulder
chanel business
chanel 2.55
louis vuitton bags
louis vuitton handbags
louis vuitton purse
louis vuitton wallet
louis vuitton belt
louis vuitton briefcase
louis vuitton travel
louis vuitton luggage
louis vuitton messeger
louis vuitton designer
louis vuitton discount
louis vuitton sale
louis vuitton store
louis vuitton stock
louis vuitton shop
louis vuitton collection
buy louis vuitton
cheap louis vuitton
lv bags
lv handbags
lv purse
lv wallet
lv belt
discount lv
buy gucci
cheap gucci
cheapest gucci
discount gucci
gucci sale
gucci bags
gucci handbags
gucci purse
gucci belt
gucci wallet
gucci shop
gucci store
gucci designer
gucci messenger
gucci diaper
gucci large
gucci medium
gucci travel
gucci shoulder
gucci business
gucci d gold
gucci flap
discount tiffany jewelry
In January of ’09, the Material Girl was spotted on the streets of New York carrying an oversized replica handbags . When paired with her metallic sweater, jeans, and fur-accented coat, the colorful replica bags made a bold fashion statement.
we provides you the best and most fashionable products. All the products are 100% high quality, competitive price, free shipping with best and timely service, 100% satisfaction. Big discount for big order. Welcome to make your choose.
ugg discount boots
cheap ugg boots
ugg boots cheap
discount uggs boots
ugg cardy boots
discount uggs
discounted ugg boots
cheap uggs boots
uggs for cheap
ugg
ugg boots
ugg shoes
ugg tall boots
ugg short boots
ugg boots sale
ugg boots on sale
ugg boots on cheap
ugg discount
uggs
discount uggs
ugg sale
ugg kids
ugg women
ugg men
cheap ugg
gucci
gucci handbags
gucci bags
gucci wallet
gucci shoes>
gucci sunglasses
gucci men
gucci women
gucci cheap
gucci discount
gucci outlet
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
ugg discount boots
cheap ugg boots
ugg boots cheap
discount uggs boots
ugg cardy boots
discount uggs
discounted ugg boots
cheap uggs boots
uggs for cheap
ugg
ugg boots
ugg shoes
ugg tall boots
ugg short boots
ugg boots sale
ugg boots on sale
ugg boots on cheap
ugg discount
discount ugg
uggs
discount uggs
ugg sale
ugg kids
ugg women
ugg men
cheap ugg
weight loss
diet pills
how to lose weight fast
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
lv
discount handbags
louis vuitton bags
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
lv
discount handbags
louis vuitton bags
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
bridal shoes
sexy shoes
high heels shoes
rosetta stone
rosetta stone software
rosetta
chaojimengnan supplier
chaojimengnan
mbt
mbts
mbt shoes
chesp mbt shoes
walking shoes
discount shoes
comfort shoes
discount mbt shoes
mbt
mbts
mbt shoes
chesp mbt shoes
walking shoes
discount shoes
comfort shoes
discount mbt shoes
mbt
mbts
mbt shoes
chesp mbt shoes
walking shoes
discount shoes
comfort shoes
discount mbt shoes
Apidexin review : Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon.