-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
1/57
Ahkoizbigh ahiHGBWB@iwshguaa`i bn iuoth oqwigbs go `iwosabkc`h go gbwhq
Jhq K`fuon Whssoq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
2/57
Ahkoizbigh ahi HGbwb
@iwshguaa`i bn iuoth oqwigbs go`iwosabkc`h go gbwhq
Jhq K`fuon Whssoq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
3/57
BAOSAB GON B_WHS:
Jhq K`fuon Whssoq wsbcbjb ahkh Soq}hiqbcno go @%G%` oi KSV Auoiwb ahi kqgo 22 bhq go o|}os`oia`b Oq buwhs lbc`wubn goqgo on bh 3==2 oi sot`qwbqoq}oa`bn`zbgbq gon qoawhs. lbc`oigh }ucn`abgh uib fsbi tbs`ogbg go bswaunhq qhcsowoaihnhfb K`ashqhdw Oq wbkc`i buwhs go ghq n`cshq qhcso QRN Qostos Ahk}baw
Lb q`gh soahiha`gh ahkh KT] oi nb abwofhs`b goGot`ao B}}n`abw`hi Gotonh}koiwgoqgo on bh 3==
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
4/57
AHKOIZBIGH AHI HGBWB@IWSHG_AA@I BN I_OTH OQWIGBS GO @IWOSABKC@H GO GBWHQ
Ih oqw }osk`w`gb nb so}shguaa`i whwbn h }bsa`bn go oqwo n`csh. i` qu wsbwbk`oiwh `idhskw`ah. i` nbwsbiqk`q`i go i`ifuib dhskb h }hs aubnru`os kog`h. pb qob onoawsi`ah. koai`ah. }hs dhwhah}`b.}hs sof`qwsh u hwshq kwhghq. q`i on }osk`qh }sot`h p }hs oqas`wh go nhq w`wunbsoq gon Ah}ps`flwG`sjbqo b AOGSH ,Aoiwsh Oq}bhn go Gosoalhq So}shfsd`ahq. vvvaogshhsf) q` ioaoq`wb
dhwhah}`bs h oqabiobs bnfi dsbfkoiwh go oqwb hcsb
GOSOALHQ SOQOSTBGHQ 3=2=. soq}oawh b nb }s`kosb og`a`i oi oq}bhn. }hs
Esbq`q Ahiqunw`if. Q NvvvEsbq`qahk
http://www.cedro.org/http://www.cedro.org/http://www.krasis.com/http://www.krasis.com/http://www.cedro.org/ -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
5/57
t
Ahiwoi`gh
@IWSHG_AA@I B HGBWB 22)+Woaihnhfbq Bawubnoq )))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) 23)+Nk`woq go nhq Qost`a`hq Voc ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) 7
D_IGBKOIWHQ GO HGBWB 62)+Ahiao}whq anbto go HGbwb )))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
6/57
Qfuoihq p goqaucs`sq nhq kojhsoq wsuahq p soausqhq:
Wo `iwosoqb oqwo n`csh8Ahk}sb on n`csh onoawsi`ah oi iuoqwsb w`oigb: lww}:((qlh})abk}uqkt})ahk
Oq}oa`bn`qwbq oi dhskba`i hin`io p n`cshq
go woaihnhfbq K`ashqhdw)
+ Oi dhskbwh ]GD
+ Q`i GSK
+ @k}s`k`cno
+ Cuqab oi on ahiwoi`gh
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
7/57
2
AB]W_NH
Oi oqwo kbiubn tbkhq b oqwug`bs ru oq H}oi Gbwb ]shwhahn +wbkc`i ahiha`gh ahkhHGbwb+. nb wohsb oi nb ruo qo cbqb. on }hsru go qu ioaoq`gbg p wbkc`i ahkh}hgokhq foiosbs p ahiquk`s hsfoioq go gbwhq cbjh g`alh oqwigbs oi nb }saw`ab Onhcjow`th oq ruo }uogbq uqbs oqwo ghaukoiwh ahkh lossbk`oiwb go b}soig`zbjo. }oshwbkc`i ahkh onokoiwh go ahiqunwb aubigh ioaoq`woq tos bnfi gowbnno kq wos`ahBnfuibq }bswoq gon k`qkh qhi cbqwbiwo s`gbq. }oqo b ruo lokhq wsbwbgh go q`iwow`zbs gonb dhskb kq ahk}soiq`cno }hq`cno nbq oq}oa`d`aba`hioq gon }shwhahnh }osh oiwoigokhqruo qhi ioaoqbs`bq }bsb ahiqofu`s }bsb oiwoigos on duia`hibk`oiwh p }oaun`bs`gbgoq goHGbwb Ih wo goqbi`koq p bn d`ibn woigsq uib cuoib t`q`i wbiwh ahiao}wubn ahkh}saw`ab go oqwo okosfoiwo oqwigbs go `iwosabkc`h go gbwhq oiwso b}n`aba`hioq
2+ WOAIHNHFBQ BAW_BNOQ]bsb oiwoigos nb uw`n`gbg sobn ruo hdsoao HGbwb wsbwokhq go `kbf`ibs ui oqaoibs`h
oi on ruo woifbkhq on soru`q`wh go ahk}bsw`s ui hs`foi go gbwhq b wsbtq go woaihnhfb@iwosiow Oqaoibs`hq ahkh oi on ruo oi kualbq habq`hioq ihq lokhq oiahiwsbgh ahkhgoqbsshnnbghsoq. p oi on ruo ihq lbi qhn`a`wbgh woios baaoqh b gowosk`ibgb `idhskba`igo nb cbqo go gbwhq go }shguaa`i }bsb nb asoba`i go @idhskoq. }hs ojok}nh gbwhq gotoiwbq }bsb on `idhskoq gon Go}bswbkoiwh D`ibia`osh Oi oqwhq oqaoibs`hq }hgokhqo|}hios nhq gbwhq uw`n`zbigh nhq koabi`qkhq go so}n`aba`i p q`iashi`zba`i go nbkbphsb go cbqoq go gbwhq ok}soqbs`bnoq Q`i okcbsfh. aubigh woiokhq ruo ahk}bsw`s
nhq gbwhq duosb go nb @iwosiow ahs}hsbw`tb b wsbtq go @iwosiow. h `ianuqh b wsbtq go nb}sh}`b @iwsbiow go nb ahk}bb ,}hs ojok}nh q` on Go}bswbkoiwh D`ibia`osh }uogo oqwbsuc`abgh oi Kbgs`g p nhq gbwhq oqwi oi Cbsaonhib). oiwhiaoq nhq koabi`qkhq goq`iashi`zba`i p so}n`aba`i ih q`ok}so qhi tn`ghq Bgokq. nhq q`qwokbq goso}n`aba`i p q`iashi`zba`i w`oioi ui ahqwo onotbgh p kq q` on hcjow`th gon duwush
an`oiwo ih oq i`abkoiwo ahiqunwbs q`ih bgokq khg`d`abs
@iwshguaa`i b HGbwb
2
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
8/57
3 Ahkoizbigh ahi HGbwb
D`fusb 2+ Oqaoibs`h w}`ah go so}n`aba`i kunw`+qogo
Hwsh oqaoibs`h w}`ah oq aubigh ahk}bsw`khq gbwhq ahi wosaoshq p bgokq go nbg`qwbia`b fohfsd`ab woiokhq nb cbssosb go nb }nbwbdhskb. }uoq nhq an`oiwoq go g`alhqhsfoioq uw`n`zbi uib }nbwbdhskb g`qw`iwb b nb iuoqwsb h qoia`nnbkoiwo uib woaihnhfbg`dosoiwo p ih `iwosh}osbcno Oq oi oqwo }uiwh gigo nhq oqwigbsoq uw`n`zbghq}s`ia`}bnkoiwo oi nhq Qost`a`hq Voc quonoi qos nb qhnua`i
Bawubnkoiwo ahiwbkhq ahi Q`w`hq Voc p Qost`a`hq Voc
Oi on }s`kos abqh ojoauwbkhq b}n`aba`hioq ruo oi koihs h kbphs kog`gb lbaoi uqhgo uib cbqo go gbwhq. oq goa`s ih qhi kq ruo uib `iwosdbz fsd`ab cbqbgb oi oqwigbsoqgo Voc ahkh LWW] h LWKN. }hs ojok}nh. }bsb nb kbi`}unba`i go gbwhq oi cbqo bnahk}hswbk`oiwh ruo oq}oa`d`ruo nb b}n`aba`i h ahkikoiwo ahiha`gb qu nf`ab goiofha`h Oi sobn`gbg ui Q`w`h Voc ih oq uib }nbwbdhskb go `iwosabkc`h }bsb ahk}bsw`sgbwhq
Nhq Qost`a`hq Voc. }hs qu }bswo. hau}bi on luoah ruo nbq b}n`aba`hioq Voc ihbcbsabi. hdsoa`oigh ahk}hswbk`oiwhq b wsbtq go kwhghq o|}uoqwhq cbjh ui ahiwsbwhahkh nh oq Voc Qost`ao God`i`w`hi Nbifubfo ,VQGN). p }oqo b ruo qo lbi toi`ghuw`n`zbigh ahkh }nbwbdhskb go `iwosabkc`h go gbwhq nb }sh}`b ibwusbnozb go nhqQost`a`hq Voc lbaoi ruo ih qob q`ok}so nb qhnua`i god`i`w`tb ahkh tosokhq bahiw`iuba`i
D`jkhihq oi nb q`fu`oiwo `nuqwsba`i ]hifbkhq ui abqh }saw`ah oi on ruo ui Q`w`hVoc p ui Qost`a`h Voc o|}hioi. abgb uih cbjh quq }sh}`bq }oaun`bs`gbgoq. uiahijuiwh go gbwhq go uib gowosk`ibgb cbqo go gbwhq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
9/57
@iwshguaa`i b HGbwb 1
D`fusb 3+ Dshiwbnoq go baaoqh b gbwhq ahi qost`a`hq Voc
B}bsoiwokoiwo p goqgo lbao bnfi w`ok}h qo lb woi`gh nb }osao}a`i ruo gigo oiwsk`ihq go `iwosh}osbc`n`gbg ih nnofbcb ui Q`w`h Voc nnofbcb ui Qost`a`h Voc P oqa`oswh ruo fsba`bq b woaihnhfbq ahkh SOQW. bgokq go QHB]. lbi loalh }hq`cno ruonhq hsfoioq go gbwhq }ug`osbi qos o|}uoqwhq ahkh Qost`a`hq Voc go dhskb ruo}ug`osbi qos souw`n`zbghq }hs tbs`bq b}n`aba`hioq(}nbwbdhskbq an`oiwo Go loalh. ih oqo|wsbh oiahiwsbs Qost`a`hq Voc ahi uib god`i`a`i q`k`nbs b nb ruo qo kuoqwsb oi nbq`fu`oiwo d`fusb. oi nb ruo qo o|}hioi nbq h}osba`hioq sonba`hibnoq cq`abq p ruo q`stoiahkh ahnukib toswocsbn go b}n`aba`hioq AS_G ,q`fnbq go Asobwo. Sobg. _}gbwo pGonowo):
D`fusb 1+ Qost`a`h Voc }bsb h}osba`hioq AS_G
O|`qwoi kualhq go qost`a`hq go oqwo oqw`nh ruo oqwi h}osbw`thq. }osh q`i okcbsfhi`abkoiwo o|}hioi on i`ton go gowbnno ruo on goqbsshnnbghs lb asogh h}hswuih
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
10/57
7 Ahkoizbigh ahi HGbwb
o|}hios Ih hcqwbiwo q` nh ruo qo }osq`fuo oq nb souw`n`zba`i. abq` ahi whgb qofus`gbg onqost`a`h qo gocos o|woigos }bsb ruo +}hs ojok}nh+ aucsb nb ioaoq`gbg go uib iuotbb}n`aba`i ruo soru`oso nb cqruogb h chssbgh go An`oiwo }hs gowosk`ibgb ]sht`ia`b wbnp ahkh qo kuoqwsb oi nb q`fu`oiwo d`fusb:
D`fusb 7+ Qost`a`h Voc o|woig`gh }bsb uib ioaoq`gbg }bsw`aunbs
Onnh `k}n`ab nb khg`d`aba`i gon ahiwsbwh gon qost`a`h ,gon VQGN oi god`i`w`tb) p}uogo woios ui onotbgh `k}bawh qhcso nbq b}n`aba`hioq o|`qwoiwoq Ahkh }hgokhq
hcqostbs. oqwo w`}h go qhnua`hioq w`oioi bnfuibq n`k`wba`hioq Tobkhq aunoq qhi
3+ NK@WOQ GO NHQ QOST@A@HQ VOCLbqwb blhsb. ahkh lokhq }hg`gh ahk}shcbs. aubnru`os khg`d`aba`i `k}n`ab ui
abkc`h oi on Qost`a`h Voc. p oqwo qosb on kojhs go nhq abqhq }uoq }uogo quaogos ruo onQost`a`h Voc oqw goqbsshnnbgh }hs ui wosaosh) Go bnfuib dhskb oqwbkhq bwbghq b nhruo on goqbsshnnbghs lb asogh ahitoi`oiwo o|}hios p ih i`abkoiwo b nh ru lbo|}uoqwh. q`ih bgokq bn akh nh lb o|}uoqwh)
]oiqokhq }hs ui `iqwbiwo nb abiw`gbg h}osba`hioq ruo }hgokhq ojoauwbs ahiwsb nbqcbqoq go gbwhq bawubnoq: d`nwsbghq. hsgoibghq. kbi`}unba`i. }shpoaa`hioq. duia`hioq
qhcso doalbq. oiwoshq h abgoibq p bq ui nbsfh owawosb @kbf`iokhq ruo go bnfuibdhskb }ug`sbkhq lbcnbs ui noifubjo oqwigbs ahi on Qost`a`h Voc go nb k`qkbdhskb ruo nh lbaokhq ahi iuoqwsb cbqo go gbwhq. p ruo aubigh woifbkhq ui iuothsoru`q`wh p ioaoq`wokhq ahiqunwbs nhq 2= an`oiwoq ruo kq lbi dbawusbgh gusbiwo uikoq. }ug`sbkhq ojoauwbs nb ahiqunwb oi on qost`a`h p ruo qwo ihq gothnt`osb onsoqunwbgh qhn`a`wbgh @kbf`iokhq ruo on dhskbwh gon ahijuiwh go gbwhq soqunwbiwoduia`hibsb wbiwh }bsb b}n`aba`hioq V`ighvq ahkh }bsb b}n`aba`hioq ]L]. oq goa`s ruolbcnbsb kog`biwo bnfi oqwigbs Go oqwb dhskb ih woigsbkhq ruo ojoauwbs uibh}osba`i go hcwoia`i go whghq nhq an`oiwoq oi on qost`ghs p ojoauwbs nb h}osba`i go
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
11/57
@iwshguaa`i b HGbwb ?
d`nwsbgh oi on nbgh an`oiwo }bsb hcwoios nhq 2= an`oiwoq ruo kq lbi dbawusbgh wbn p ahkhqo gocosb lbaos bawubnkoiwo
Oi god`i`w`tb H}oi Gbwb ]shwhahnoq nb soq}uoqwb b oqwo iuoth oqaoibs`h ruo pbih oq `kbf`ibs`h. oq sobn p oqwo kbiubn }sowoigo }soqoiwbs nbq absbawosqw`abq bi kqwsbqaoigoiwoq ruo lbao `ig`q}oiqbcno ahihaos bn koihq. nbq chigbgoq go oqwb
woaihnhfb
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
12/57
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
13/57
6
AB]W_NH
Oi on ab}wunh biwos`hs lbcnbkhq go ui noifubjo ruo ui Qost`a`h Voc }ug`osboiwoigos go wbn dhskb ruo }ug`osb ojoauwbs h}osba`hioq sonba`hibnoq p ruo bgokq oqwonoifubjo duosb oqwigbs Oqwh oq }soa`qbkoiwo nh ruo K`ashqhdw lb cuqabgh ahi H}oiGbwb ]shwhahn go dhskb ruo qo aoiwsb oi wsoq hcjow`thq anbshq:
Asobs uib dhskb ui`dhsko go so}soqoiwba`i go gbwhq oqwsuawusbghq b wsbtq gooqwigbsoq ahkh Bwhk p JQHI
_w`n`zbs ahitoia`hioq _SN ui`dhskoq }bsb nb ibtofba`i. d`nwsbgh. hsgoi p}bf`iba`i go gbwhq oiwso hwshq
Asobs h}osba`hioq ui`dhskoq g`s`f`gbq }hs g`soaa`i p oqwbigbs`zba`i go nbqbaa`hioq FOW. ]HQW. ]_W p GONOWO }bsb nb ahiqunwb p kbi`}unba`i gogbwhq
Oqwhq wsoq }`nbsoq ahidhskbi H}oi Gbwb ]shwhahn ,HGbwb oi bgonbiwo)HGbwb ih oq kq ruo uib oqwbigbs`zba`i. b wsbtq go nb Abswb go Ahk}shk`qh go
K`ashqhdw +K`ashqhdwq H}oi Q}oa`d`abw`hi ]shk`qo ,HQ])+. go nb foiosba`i pahiqukh go gbwhq tb Voc Oqw ahiqwsu`gh qhcso ui ahijuiwh go oqwigbsoq go@iwosiow. oq}oa`bnkoiwo qhcso Bwhk ]ucn`ql`if ]shwhahn h Bwhk]uc oq}oa`d`abgh oiSDA ?=31. ru`i b qu toz oqw ahiqwsu`gh qhcso Bwhk Qpig`abw`hi Dhskbw,hq`k}nokoiwo Bwhk oq}oa`d`abgh oiSDA 73
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
14/57
8|kntosq`hi;#2=#oiahg`if;#uwd+ogk|:Ogk|Tosq`hi;#2=#
Ihwb: Qo o|}hio on oru`tbnoiwo go nhq onokoiwhq uw`n`zbghq oi HGbwb oi `ifnq}bsb ruo ihq dbk`n`bs`aokhq ahi oqwhq wsk`ihq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
15/57
Duigbkoiwhq go HGbwb 0
|kniq:ogk|;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=4(ogk|#9>ogk|:GbwbQost`aoq
|kniq:k;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=QalokbIbkoq}bao;#HGbwbGokh#|kniq:g;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=Eop9>]sh}oswpSodIbko;#@G# (9
>(Eop9>]sh}oswpIbko;#@G#Wp}o;#Ogk@iw13#Iunnbcno;#dbnqo# (9>]sh}oswpIbko;#Ibko#Wp}o;#OgkQws`if#Iunnbcno;#wsuo#
k:DAXWbsfow]bwl;#Qpig`abw`hiW`wno#k:DAXAhiwoiwE`ig;#wo|w#k:DAXEoo}@iAhiwoiw;#dbnqo# (9
>]sh}oswpIbko;#Goqas`}w`hi#Wp}o;#OgkQws`if#Iunnbcno;#wsuo#k:DAXWbsfow]bwl;#Qpig`abw`hiQukkbsp#k:DAXAhiwoiwE`ig;#wo|w#k:DAXEoo}@iAhiwoiw;#dbnqo# (9
>]sh}oswpIbko;#SonobqoGbwo#Wp}o;#OgkGbwoW`ko#Iunnbcno;#dbnqo#(9
>]sh}oswpIbko;#G`qahiw`iuogGbwo#Wp}o;#OgkGbwoW`ko#Iunnbcno;#wsuo# (9
>]sh}oswpIbko;#Sbw`if#Wp}o;#Ogk@iw13#Iunnbcno;#dbnqo# (9>]sh}oswpIbko;#]s`ao#Wp}o;#OgkGoa`kbn#Iunnbcno;#dbnqo# (9>Ibt`fbw`hi]sh}oswpIbko;#Abwofhsp#
Sonbw`hiql`};#HGbwbGokh]shguawXAbwofhspXAbwofhspX]shguawq#DshkShno;#]shguawXAbwofhsp#WhShno;#AbwofhspX]shguawq# (9
>Ibt`fbw`hi]sh}oswpIbko;#Qu}}n`os#Sonbw`hiql`};#HGbwbGokh]shguawXQu}}n`osXQu}}n`osX]shguawq#DshkShno;#]shguawXQu}}n`os#WhShno;#Qu}}n`osX]shguawq# (9
>(Oiw`wpWp}o9>Oiw`wpWp}oIbko;#Abwofhsp#9
>Eop9>]sh}oswpSodIbko;#@G# (9
>(Eop9>]sh}oswpIbko;#@G#Wp}o;#Ogk@iw13#Iunnbcno;#dbnqo# (9>]sh}oswpIbko;#Ibko#Wp}o;#OgkQws`if#Iunnbcno;#wsuo#
k:DAXWbsfow]bwl;#Qpig`abw`hiW`wno#k:DAXAhiwoiwE`ig;#wo|w#k:DAXEoo}@iAhiwoiw;#wsuo# (9
>Ibt`fbw`hi]sh}oswpIbko;#]shguawq#Sonbw`hiql`};#HGbwbGokh]shguawXAbwofhspXAbwofhspX]shguawq#DshkShno;#AbwofhspX]shguawq#WhShno;#]shguawXAbwofhsp# (9
>(Oiw`wpWp}o9>Oiw`wpWp}oIbko;#Qu}}n`os#9>Eop9>]sh}oswpSodIbko;#@G# (9
>(Eop9>]sh}oswpIbko;#@G#Wp}o;#Ogk@iw13#Iunnbcno;#dbnqo# (9>]sh}oswpIbko;#Ibko#Wp}o;#OgkQws`if#Iunnbcno;#wsuo#
k:DAXWbsfow]bwl;#Qpig`abw`hiW`wno#k:DAXAhiwoiwE`ig;#wo|w#k:DAXEoo}@iAhiwoiw;#wsuo# (9
>]sh}oswpIbko;#Bggsoqq#Wp}o;#HGbwbGokhBggsoqq#Iunnbcno;#dbnqo#(9
>]sh}oswpIbko;#Ahiaussoiap#Wp}o;#Ogk@iw13#Iunnbcno;#dbnqo#AhiaussoiapKhgo;#D`|og# (9
>Ibt`fbw`hi]sh}oswpIbko;#]shguawq#Sonbw`hiql`};#HGbwbGokh]shguawXQu}}n`osXQu}}n`osX]shguawq#DshkShno;#Qu}}n`osX]shguawq#WhShno;#]shguawXQu}}n`os# (9
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
16/57
2= Ahkoizbigh ahi HGbwb
>(Oiw`wpWp}o9>Ahk}no|Wp}oIbko;#Bggsoqq#9>]sh}oswpIbko;#Qwsoow#Wp}o;#OgkQws`if#Iunnbcno;#wsuo# (9>]sh}oswpIbko;#A`wp#Wp}o;#OgkQws`if#Iunnbcno;#wsuo# (9>]sh}oswpIbko;#Qwbwo#Wp}o;#OgkQws`if#Iunnbcno;#wsuo# (9>]sh}oswpIbko;#Z`}Ahgo#Wp}o;#OgkQws`if#Iunnbcno;#wsuo# (9>]sh}oswpIbko;#Ahuiwsp#Wp}o;#OgkQws`if#Iunnbcno;#wsuo# (9
>(Ahk}no|Wp}o9>Bqqha`bw`hiIbko;#]shguawXAbwofhspXAbwofhspX]shguawq#9>OigShno;#]shguawXAbwofhsp#Wp}o;#HGbwbGokh]shguaw#
Kunw`}n`a`wp;#*# (9>OigShno;#AbwofhspX]shguawq#Wp}o;#HGbwbGokhAbwofhsp#
Kunw`}n`a`wp;#=2# (9>(Bqqha`bw`hi9>Bqqha`bw`hiIbko;#]shguawXQu}}n`osXQu}}n`osX]shguawq#9>OigShno;#]shguawXQu}}n`os#Wp}o;#HGbwbGokh]shguaw#
Kunw`}n`a`wp;#*# (9>OigShno;#Qu}}n`osX]shguawq#Wp}o;#HGbwbGokhQu}}n`os#
Kunw`}n`a`wp;#=2# (9
>(Bqqha`bw`hi9>Oiw`wpAhiwb`iosIbko;#GokhQost`ao#
k:@qGodbunwOiw`wpAhiwb`ios;#wsuo#9>Oiw`wpQowIbko;#]shguawq#Oiw`wpWp}o;#HGbwbGokh]shguaw# (9>Oiw`wpQowIbko;#Abwofhs`oq#Oiw`wpWp}o;#HGbwbGokhAbwofhsp# (9>Oiw`wpQowIbko;#Qu}}n`osq#Oiw`wpWp}o;#HGbwbGokhQu}}n`os# (9>Bqqha`bw`hiQowIbko;#]shguawqXAbwofhspXAbwofhs`oq#
Bqqha`bw`hi;#HGbwbGokh]shguawXAbwofhspXAbwofhspX]shguawq#9>OigShno;#]shguawXAbwofhsp#Oiw`wpQow;#]shguawq# (9>OigShno;#AbwofhspX]shguawq#Oiw`wpQow;#Abwofhs`oq# (9
>(Bqqha`bw`hiQow9>Bqqha`bw`hiQowIbko;#]shguawqXQu}}n`osXQu}}n`osq#
Bqqha`bw`hi;#HGbwbGokh]shguawXQu}}n`osXQu}}n`osX]shguawq#9>OigShno;#]shguawXQu}}n`os#Oiw`wpQow;#]shguawq# (9
>OigShno;#Qu}}n`osX]shguawq#Oiw`wpQow;#Qu}}n`osq# (9>(Bqqha`bw`hiQow9
>Duiaw`hi@k}hswIbko;#Fow]shguawqCpSbw`if#Oiw`wpQow;#]shguawq#SowusiWp}o;#Ahnnoaw`hi,HGbwbGokh]shguaw)#k:Lww}Kowlhg;#FOW#9
>]bsbkowosIbko;#sbw`if#Wp}o;#Ogk@iw13#Khgo;#@i# (9>(Duiaw`hi@k}hsw9
>(Oiw`wpAhiwb`ios9>(Qalokb9
>(ogk|:GbwbQost`aoq9>(ogk|:Ogk|9
On Qost`ao Kowbgbwb Ghaukoiw oqw goqas`wh }hs OGK go dhskb ruo qob`igo}oig`oiwo bn dhskbwh oi ruo qo ru`osb o|}hios ,JQHI. Bwhk) Nh i`ah ruo o|`fo
oq ruo qo o|}hifb b wsbtq go uib `iwosdbz LWW] OGK oqw goqas`wh oi noifubjo \KNq`fu`oigh nb goqas`}a`i go khgonhq gon nnbkbgh noifubjo go god`i`a`i go oqruokbqahiao}wubnoq h Ahiao}wubn Qalokb God`i`w`hi Nbifubfo ,AQGN oi bgonbiwo)
Oqwbq qhi nbq anbtoq go nb oq}oa`d`aba`i HGbwb pb ruo ih ahk}shkowoi nboqwsuawusb go gbwhq b dhskbwhq }sh}`owbs`hq q`ih ruo s`foi nb dhskb oi ruo nbqoqwsuawusbq go oiwsbgbq gocoi qos o|}uoqwbq
Oi nb q`fu`oiwo wbcnb }hgokhq tos nhq g`dosoiwoq w`}hq go soausqhq goqas`whq oi onOiw`wp Gbwb Khgon
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
17/57
Duigbkoiwhq go HGbwb 22
Wbcnb 2+ Soausqhq HGbwb
Soausqh Goqas`wh oi on OGK }hs
Ahnnoaw`hiAhnoaa`i+
Ahijuiwh go oiw`gbgoq _ib }sh}`ogbg goibtofba`i ruo `goiw`d`abuib ahnoaa`i go oiw`gbgoq
OiwspOiwsbgb+ W`}h go nb oiw`gbg Ihwb: Nhq w`}hq go nbq
oiw`gbgoq gocoi dhskb }bswogo nb josbsrub go w`}hq
]sh}oswp hd bi oiwsp]sh}`ogbggo uib oiwsbgb+
]sh}`ogbg go w`}h ]s`k`w`tbh Ahk}nojb
Ahk}no| Wp}oW`}h Ahk}nojh+ W`}h Ahk}nojhN`ieOinbao+ ]sh}`ogbg go ibtofba`i
god`i`gb oi on w`}h go oiw`gbg
Qost`ao H}osbw`hi H}osba`igo Qost`a`h+
Duia`i
Oi nb Wbcnb 3 qo sodnojb nb sonba`i go nhq w`}hq go gbwhq }s`k`w`thq p qu o|}soq`in`wosbn oi on OGK:
Wbcnb 3+ W`}hq go gbwhq }s`k`w`thq
W`}h ]shk`w`th Dhskb N`wosbn Ojok}nh
IunnSo}soqoiwb nbbuqoia`b go tbnhs
iunn Ojok}nh 2:iunn
OgkC`ibspSo}soqoiwb ui gbwhc`ibs`h go nhif`wugd`jb h tbs`bcno
c`ibsp&UB+Db+d=+0[UB+Db+d=+0[*& H \&UB+Db+d=+0[UB+Db+d=+0[*&
Ojok}nh 2:\&31BC&
Ojok}nh 3:c`ibsp&31BCDD&
OgkChhnobiSo}soqoiwb onahiao}wh go ui tbnhsnf`ah
wsuo ~ dbnqo Ojok}nh 2:wsuo Ojok}nh 3:dbnqo
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
18/57
23 Ahkoizbigh ahi HGbwb
OgkCpwoTbnhs oiwosh q`i q`fihgo
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
19/57
Duigbkoiwhq go HGbwb 21
ahi q`fih go 24+c`wOgk@iw13
So}soqoiwb ui oiwosh
ahi q`fih go 13+c`w
U+[ U=+0[% Ojok}nh 2: 13Ojok}nh 3: +13
Ogk@iw47So}soqoiwb ui oiwoshahi q`fih go 47+c`w
U+[ U=+0[%N Ojok}nh 2:47N Ojok}nh 3: +47N
OgkQCpwoSo}soqoiwb ui oiwoshahi q fih go w`koN`wosbn9& w`koN`wosbn ;God`i`gh }hs nb so}soqoiwba`i n|`ab gonb lhsb oilww}:((vvvv1hsf(WS(|knqalokb+3
Ojok}nh 2:21:3=:==
OgkGbwoW`koHddqowSo}soqoiwb uib doalbu lhsb sonbw`tb b nb
lhsb ui`tosqbnahhsg`ibgb _AW ahitbnhsoq ahk}soig`ghqoiwso nbq =:==:== go nbkog`b ihalo gon gb 2go Oiosh go 26?1lbqwb nbq 31:?0:?0 gon0000
gbwow`kohddqow&>gbwoW`koHddqowN`wosbn9&gbwoW`koHddqowN`wosbn ; God`i`gh }hs nbso}soqoiwba`i n|`ab }bsb gbwow`ko oilww}:((vvvv1hsf(WS(|knqalokb+3
Ojok}nh 2:3==3+2=+2=W26:==:==Z
http://tools.ietf.org/html/rfc3629http://tools.ietf.org/html/rfc3629http://tools.ietf.org/html/rfc3629http://www.w3.org/TR/xmlschema-2http://www.w3.org/TR/xmlschema-2http://www.w3.org/TR/xmlschema-2http://www.w3.org/TR/xmlschema-2http://www.w3.org/TR/xmlschema-2http://www.w3.org/TR/xmlschema-2http://tools.ietf.org/html/rfc3629 -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
20/57
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
21/57
2?
AB]W_NH
]bsb o|}hios uib qos`o go soausqhq god`i`ghq cbjh on khgonh go gbwhq OGK. oi uiqost`a`h go gbwhq cbqbgh oi SOQW p q`fu`oigh nbq oq}oa`d`aba`hioq HGbwb. qo gocoiqofu`s uibq ahitoia`hioq oi nh ruo soq}oawb b nb _S@ ,_i`dhsk Soqhusao @igow`d`os) On}s`kos }bqh ioaoqbs`h }bsb ahk}soigos on duia`hibk`oiwh go HGbwb oq ahihaos g`albqahitoia`hioq }hs onokoiwhq
2+ AHK]HIOIWOQ _S@On _S@ uw`n`zbgh }hs ui qost`a`h HGbwb ahiqwb go wsoq }bswoq:
On _S@ sbz gon qost`a`h Nb g`soaa`i go nhq soausqhq Nb abgoib go h}a`hioq go ahiqunwb
Nb D`fusb 2 `nuqwsb oqwhq onokoiwhq:
D`fusb 2+ Ahk}hioiwoq _S@
On q`fu`oiwo ojok}nh so}soqoiwbsb nb ahiqunwb ruo ihq }osk`w`sb hcwoios nhq ghq}s`koshq ]shguawhq go nb Abwofhs`b `goiw`d`abgb b wsbtq go nb anbto }s`kbs`b ahi tbnhs2 p hsgoibghq }hs bndbcw`abkoiwo }hs qu ihkcso:
Ahiquk`oigh gbwhq bwsbtq go HGbwb
1
http://www.odata.org/images/ODataUri.pnghttp://www.odata.org/images/ODataUri.pnghttp://www.odata.org/images/ODataUri.pnghttp://www.odata.org/images/ODataUri.png -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
22/57
24 Ahkoizbigh ahi HGbwb
D`fusb 3+ Ojok}nh go _S@ ahi quq onokoiwhq kbsabghq
3+ AHIQ_NWBQ CQ@ABQWhgbq nbq ahiqunwbq qhcso oiw`gbgoq cq`abq. oiw`gbgoq bfsu}bgbq oi ahnoaa`hioq h
}sh}`ogbgoq go oiw`gbgoq. }uogoi qos ahiqunwbgbq kog`biwo nb g`soaa`i go soausqhqB ahiw`iuba`i qo gowbnnbi nbq goqas`}a`hioq go nhq onokoiwhq ibtofbcnoq:
Ahnnoaw`hi: On ihkcso go nb ahnoaa`i u h}osba`i ruo gotuonto uib ahnoaa`igo oiwsbgbq o|}uoqwbq }hs on qost`a`h
Eop]sog`abwo: _i }sog`abgh ruo `goiw`d`ab on(nhq tbnhsoq go nbq }sh}`ogbgoqgo anbto go uib Oiwsbgb Q` nb Oiwsbgb w`oio uib i`ab ]sh}`ogbg Anbto on}sog`abgh }uogo `ianu`s i`abkoiwo on tbnhs go nb }sh}`ogbg anbto Q` nb anbtow`oio kq go ui tbnhs oiwhiaoq on tbnhs goco qos bqha`bgh bn ihkcso go nb]sh}`ogbg Anbto wbn p ahkh qo kuoqwsb oi nb q`fu`oiwo d`fusb:
D`fusb 1+ Oqwsuawusb go }sog`abgh
Ibt]sh}Q`ifno: On ihkcso go nb ]sh}`ogbg go Ibtofba`i god`i`gb }hs uibOiwsbgb p bqha`bgb ahi on qofkoiwh go g`soaa`i biwos`hs Nb ]sh}`ogbg goIbtofba`i goco `goiw`d`abs uib i`ab oiw`gbg. oq goa`s nb sonba`i oq b uih)
Ibt]sh}Ahnnoaw`hi: Nh k`qkh ruo on biwos`hs }osh nb sonba`i oq b tbs`hq) Ahk}no|Wp}o: On ihkcso go nb ]sh}`ogbg g`ik`ab h goanbsbgb go uib
Oiwsbgb h W`}h Ahk}nojh bqha`bgh bn qofkoiwh go g`soaa`i biwos`hs
]sh}oswp: On ihkcso go nb ]sh}`ogbg g`ik`ab h goanbsbgb go nb Oiwsbgb hW`}h Ahk}nojh bqha`bgh bn qofkoiwh go g`soaa`i biwos`hs
B ahiw`iuba`i }hgokhq tos ojok}nhq go bnfuihq abqhq ahkuioq:
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
23/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 26
+ Ahiqunwb go ahnoaa`hioq go oiw`gbgoq ,Ahnnoaw`hiq). oi oqwo abqh nhq gbwhq goabwofhsbq:
lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq
+ Ahiqunwb go uib i`ab oiw`gbg ,Eop]sog`abwo)lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,2)
+ Ahiqunwb go uib }sh}`ogbg go uib oiw`gbg ,]sh}oswp)lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,2)(Ibko
+ Ahiqunwb gon tbnhs go uib }sh}`ogbg go uib oiw`gbg ,]sh}oswp)lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,2)(Ibko('tbnuo
1+ SONBA@I OIWSO OIWSBGBQ]hs hwsb }bswo nb sonba`i oiwso oiwsbgbq q`fuo nb q`fu`oiwo ahitoia`i:
D`fusb 7+ Ahitoia`i go sonba`hioq oiwso Oiwsbgbq
]hs ojok}nh. }bsb ibtofbs }hs uib oiwsbgb aubnru`osb. oi iuoqwsh abqh nb n`qwb goabwofhsbq ahi @g `fubn b =. uqbsokhq nb q`fu`oiwo g`soaa`i:
lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,=)
P hcwoigsokhq on q`fu`oiwo soqunwbgh oi nb soq}uoqwb:
>8|kntosq`hi;#2=#oiahg`if;#uwd+oiwsp|kn:cbqo;#lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(#
|kniq:g;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=(`g9>w`wnowp}o;#wo|w#9Dhhg>(w`wno9
>u}gbwog93=2=+=7+31W21:33:70Z>(u}gbwog9
>buwlhs9>ibko (9
>(buwlhs9
>n`ieson;#og`w#w`wno;#Abwofhsp#lsod;#Abwofhs`oq,=)# (9>n`ie
son;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
24/57
2abwofhspwosk;#HGbwbGokhAbwofhsp#
qaloko;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=ahiwoiwwp}o;#b}}n`abw`hi(|kn#9
>k:}sh}osw`oq9>g:@Gk:wp}o;#Ogk@iw13#9=>(g:@G9
>g:Ibko9Dhhg>(g:Ibko9
>(k:}sh}osw`oq9>(ahiwoiw9
>(oiwsp9
Q` ihq d`jbkhq nb oiwsbgb w`oio ui onokoiwh >n`ie9. qobnbgh oi iofs`wb. ruogoqas`co on w`}h go sonba`i oiwso nb Abwofhsb p nhq ]shguawhq Oi on }sh}`h onokoiwh
woiokhq nb g`soaa`i go sodosoia`b go nhq }shguawhq:lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,=)(]shguawq
Q` ibtofbkhq lba`b onnb hcwoigsokhq:
>8|kntosq`hi;#2=#oiahg`if;#uwd+doog |kn:cbqo;#lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(#|kniq:g;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=(w`wno9
>`g9lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,=)(]shguawq>(`g9
>u}gbwog93=2=+=7+31W21:13:7?Z>(u}gbwog9
>n`ieson;#qond#w`wno;#]shguawq#lsod;#]shguawq# (9
>oiwsp9
>`g9lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(]shguawq,=)>(`g9
>w`wnowp}o;#wo|w#9Csobg>(w`wno9>qukkbspwp}o;#wo|w#9Vlhno fsb`i csobg>(qukkbsp9
>u}gbwog93=2=+=7+31W21:13:7?Z>(u}gbwog9>buwlhs9
>ibko (9>(buwlhs9
>n`ieson;#og`w#w`wno;#]shguaw#lsod;#]shguawq,=)# (9
>n`ieson;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=n`ie
son;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
25/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 20
lsod;#]shguawq,=)(Qu}}n`os# (9
>abwofhsp wosk;#HGbwbGokh]shguaw#
qaloko;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=ahiwoiwwp}o;#b}}n`abw`hi(|kn#9>k:}sh}osw`oq9
>g:@Gk:wp}o;#Ogk@iw13#9=>(g:@G9>g:SonobqoGbwo k:wp}o;#OgkGbwoW`ko#92003+=2+
=2W==:==:==>(g:SonobqoGbwo9
>g:G`qahiw`iuogGbwo k:wp}o;#OgkGbwoW`ko# k:iunn;#wsuo#(9
>g:Sbw`ifk:wp}o;#Ogk@iw13#97>(g:Sbw`if9
>g:]s`aok:wp}o;#OgkGoa`kbn#93?>(g:]s`ao9>(k:}sh}osw`oq9
>(ahiwoiw9>(oiwsp9
>(doog9
Iwoqo ruo on soqunwbgh oq on Qost`ao Ghaukoiwgo nb oiwsbgb ]shguawq qwo b qutoz w`oio oinbaoq god`i`ghq }hs onokoiwhq >n`ie9 b hwsbq oiw`gbgoq sonba`hibgbq. ahkhQu}}n`os p. ot`goiwokoiwo. Abwofhsp
]bsb ahiqunwbs nbq ]shguawhq ruo }oswoioaoi b nb abwofhsb biwos`hs uw`n`zbsbkhq ononokoiwh(anbto 'n`ie go nb q`fu`oiwo dhskb:
lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,=)('n`ieq(]shguawq
Hcwoi`oigh on soqunwbgh q`fu`oiwo:
>8|kntosq`hi;#2=#oiahg`if;#uwd+n`ieq
|kniq;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=us`9lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(]shguawq,=)>(us`9
>(n`ieq9
Oq goa`s uib i`ab oiwsbgb sonba`hibgb. nb ahssoq}hig`oiwo bn }shguawh ahi @g `fubn b=
7+ H]A@HIOQ GO AHIQ_NWBLbqwb blhsb lokhq t`qwh bnfuibq h}a`hioq go ibtofba`i o `iwshgua`gh.
`ig`soawbkoiwo. bnfuihq onokoiwhq go ahiqunwb ahkh 'tbnuo Bgokq. oi on nw`khojok}nh. }hgsbkhq lbcos loalh uqh go'ahuiw go nb q`fu`oiwo dhskb:
lww}:((qost`aoqhgbwbhsf(HGbwb(HGbwbqta(Abwofhs`oq,=)('n`ieq(]shguawq('ahuiw
Hcwoi`oigh ahkh soqunwbgh on ikosh go oiwsbgbq. oi iuoqwsh abqh 2
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
26/57
3= Ahkoizbigh ahi HGbwb
Q`i okcbsfh bi }hgokhq qbabs kualh kq }shtoalh b wsbtq go nbq h}a`hioq gohsgoibgh h go duia`i ahkh }hs ojok}nh'wh}
Oi nb q`fu`oiwo d`fusb qo hcqostb on soqunwbgh go uib ahiqunwb sobn`zbgb qhcso uiqost`a`h lhq}ogbgh oi nhabnlhqw. oi nb ruo qo kuoqwsbi nhq 1 }s`koshq an`oiwoqhsgoibghq }hs on abk}h D`sqwIbko go kbiosb goqaoigoiwo
D`fusb ?+ Soqunwbgh go ahiqunwb ruo gotuonto nhq wsoq }s`koshq onokoiwhq
Bgokq go nbq h}a`hioq go hsgoiba`i p wh} }hgokhq uw`n`zbs nbq q`fu`oiwoq:
72+ 'hsgoscpNb h}a`i 'hsgoscp gotuonto uib ahiqunwb hsgoibgb }hs nb(q }sh}`ogbg(oq
`ig`abgb(qBnfuihq ojok}nhq go qu uqh qhi:
+ Sowhsib uib Ahnoaa`i go Oiwsbgbq hsgoibgbq }hs nb }sh}`ogbg D`sqwIbkolww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos8'hsgoscp;D`sqwIbko
+ Nh k`qkh }osh oi dhskb bqaoigoiwo
http://localhost:12560/AdventureWorksService.svc/Customer?$orderby=FirstNamehttp://localhost:12560/AdventureWorksService.svc/Customer?$orderby=FirstNamehttp://localhost:12560/AdventureWorksService.svc/Customer?$orderby=FirstNamehttp://localhost:12560/AdventureWorksService.svc/Customer?$orderby=FirstName -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
27/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 32
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos8'hsgoscp;D`sqwIbko bqa
+ Oi on q`fu`oiwo ojok}nh qo hsgoib }s`kosh }hs on abk}h HsgosGbwo go nbOiwsbgb QbnoqHsgosLobgos p goq}uq }hs on abk}h D`sqwIbko go nb Oiwsbgboinbzbgb Auqwhkos
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(QbnoqHsgosLobgos8'hsgoscp;HsgosGbwo.Auqwhkos(D`sqwIbko
73+ 'wh}Nb h}a`i 'wh} gotuonto nbq i }s`kosbq oiwsbgbq `ig`abgbq }hs on tbnhs 'wh};iOn q`fu`oiwo ojok}nh gotuonto nhq ? }shguawhq ahi ahqwo oqwigbs kq bnwh
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw8'hsgoscp;Qwbigbs
gAhqw$'wh};?
71+ 'o|}bigOqwb h}a`i oq oq}oa`bnkoiwo w`n }bsb khqwsbs nbq sonba`hioq go kq go uib Oiwsbgb
Oq goa`s. q` }hs ojok}nh ru`q`sbkhq khqwsbs uib Oiwsbgb Auqwhkos p qu Oiwsbgbsonba`hibgb so}soqoiwbgb }hs AuqwhkosBggsoqq }hgsbkhq lbaosnh kog`biwo ghqahiqunwbq ojoauwbgbq ahiqoauw`tbkoiwo. h c`oi }hgsbkhq lbaosnh oi uib qhnb kog`biwonb h}a`i 'o|}big
On q`fu`oiwo ojok}nh `nuqwsb nb hcwoia`i gon }s`kos Auqwhkos ,'wh};2) ahiAuqwhkosBggsoqq
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos8'o|}big;AuqwhkosBggsoqq$'wh};2
Soqunwbgh:
>8|kntosq`hi;#2=#oiahg`if;#uwd+doog|kn:cbqo;#lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(#
|kniq:g;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=(w`wno9
>`g9lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos>(`g9>u}gbwog93=2=+=7+34W=n`ieson;#qond#w`wno;#Auqwhkos#lsod;#Auqwhkos# (9
>oiwsp9
>`g9lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos,2)>(
`g9>w`wnowp}o;#wo|w#9>(w`wno9>u}gbwog93=2=+=7+34W=
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
28/57
33 Ahkoizbigh ahi HGbwb
>buwlhs9
>ibko (9
>(buwlhs9
>n`ieson;#og`w#w`wno;#Auqwhkos#lsod;#Auqwhkos,2)# (9
>n`ieson;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=k:`in`io9
>doog9>w`wnowp}o;#wo|w#9AuqwhkosBggsoqq>(w`wno9
>`g9lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(Auqwhkos,2)(AuqwhkosBggsoqq>(`g9
>u}gbwog93=2=+=7+34W=buwlhs9
>ibko (9>(buwlhs9
>n`ie son;#qond# w`wno;#AuqwhkosBggsoqq#
lsod;#Auqwhkos,2)(AuqwhkosBggsoqq# (9>(doog9
>(k:`in`io9
>(n`ie9>n`ie
son;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=abwofhsp wosk;#BgtoiwusoVhseqNW3==k:}sh}osw`oq9
>g:Auqwhkos@Gk:wp}o;#Ogk@iw13#92>(g:Auqwhkos@G9>g:IbkoQwpnok:wp}o;#OgkChhnobi#9dbnqo>(g:IbkoQwpno9>g:W`wno9Ks>(g:W`wno9
>g:D`sqwIbko9Hsnbigh>(g:D`sqwIbko9>g:K`ggnoIbko9I>(g:K`ggnoIbko9
>g:NbqwIbko9Foo>(g:NbqwIbko9
>g:Qudd`|k:iunn;#wsuo# (9
>g:Ahk}bipIbko9B C`eo Qwhso>(g:Ahk}bipIbko9
>g:Qbnoq]osqhi9bgtoiwuso+vhseq^}bkonb=>(g:Qbnoq]osqhi9>g:Okb`nBggsoqq9hsnbigh=Mbgtoiwuso+
vhseqahk>(g:Okb`nBggsoqq9>g:]lhio937?+???+=261>(g:]lhio9
>g:]bqqvhsgLbql9N(Snv|z}7v6SVkOf\\%(B6a\bo]O]a}%EvRln3dJN6v;>(g:]bqqvhsgLbql9
>g:]bqqvhsgQbnw92Ej\Pq7;>(g:]bqqvhsgQbnw9
>g:shvfu`g k:wp}o;#OgkFu`g#91d?bo0?o+c
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
29/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 31
a1606bdac67d>(g:shvfu`g9
>g:Khg`d`ogGbwo k:wp}o;#OgkGbwoW`ko#93==2+=(g:Khg`d`ogGbwo9
>(k:}sh}osw`oq9
>(ahiwoiw9>(oiwsp9
>(doog9
77+ 'd`nwosD`nwsb nbq oiwsbgbq }hs uib o|}soq`i nf`ab. bs`wkw`ab h go bfsu}ba`i Tosokhq
kq gowbnnoq qhcso nbq h}a`hioq go oqwo d`nwsh oi nb q`fu`oiwo qoaa`i
7?+ '`in`ioahuiwSowhsib on ikosh go Oiwsbgbq oiahiwsbgbq oi on ghaukoiwh q` `ig`abkhq on tbnhs
'`in`ioahuiw;bnn}bfoq On tbnhs }hs godoawh oq '`in`ioahuiw;ihio]hs ojok}nh. nb q`fu`oiwo _S@ sowhsibs whghq nhq }shguawhq auph ahqwo oqwigbs qob
qu}os`hs b 3===. o `ig`abs nb abiw`gbg go oiwsbgbq ruo qbw`qdbaoi on d`nwsh kog`biwo nbuib kbsab >ahuiw9 oi on soqunwbgh:
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw8'd`nwos;QwbigbsgAhqw fw 3===$'`in`ioahuiw;bnn}bfoq
On soqunwbgh oq on q`fu`oiwo:
>8|kntosq`hi;#2=#oiahg`if;#uwd+doog|kn:cbqo;#lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(#
|kniq:g;#lww}:((qalokbqk`ashqhdwahk(bgh(3==6(=(w`wno9
>`g9lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw>(`g9
>u}gbwog93=2=+=7+34W2=:2?:1=Z>(u}gbwog9>n`ieson;#qond#w`wno;#]shguaw#lsod;#]shguaw# (9
>k:ahuiw9?>(k:ahuiw9>oiwsp9
On q`fu`oiwo ojok}nh. p oqwh oq `k}hswbiwo. }oqo b nb o|`qwoia`b go nb h}a`i 'wh};3sowhsibs wbkc`i ? oiwsbgbq oi on onokoiwh >ahuiw9. pb ruo qhi nbq ruo qo lbi}shaoqbgh oi on qost`a`h biwoq go gothntos nhq gbwhq:
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
30/57
37 Ahkoizbigh ahi HGbwb
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw8'd`nwos;QwbigbsgAhqw fw 3===$'`in`ioahuiw;bnn}bfoq$'wh};3
74+ 'qonoawOqwb h}a`i `goiw`d`ab on qucahijuiwh go }sh}`ogbgoq go ui hs`foi HGbwb b
gothntos 'qonoawi`abkoiwo oqw qh}hswbgb oi nb tosq`i 3= p qu}os`hsOi on q`fu`oiwo ojok}nh qo gothntosi i`abkoiwo nbq ]sh}`ogbgoq oq}oa`d`abgbq
ahkh tbnhs oi 'qonoaw
lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw,4
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
31/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 3?
7
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
32/57
34 Ahkoizbigh ahi HGbwb
H}osbghsoq bs`wkw`ahqBgg Qukb (]shguawq8'd`nwos;]s`ao bgg
? fw 2=
Quc Soqwb (]shguawq8'd`nwos;]s`ao quc? fw 2=
Kun Kunw`}n`aba`i (]shguawq8'd`nwos;]s`ao kun3 fw 3===
G`t G`t`q`i (]shguawq8'd`nwos;]s`ao g`t 3fw 7
Khg Kgunh (]shguawq8'd`nwos;]s`ao khg3 or =
H}osbghsoq go bfsu}bk`oiwh
, ) Bfsu}ba`i (]shguawq8'd`nwos;,]s`ao quc?) fw 2=
Bgokq o|`qwoi uib qos`o go duia`hioq }bsb nhq h}osbghsoq h duia`hioq. oq}oad`ahq}bsb on wsbwbk`oiwh go:
Abgoibq Doalbq O|}soq`hioq kbwokw`abq Go w`}h
Nbq aubnoq }hgokhq tos oi nbq q`fu`oiwoq wbcnbq. ahi ui ojok}nh bqha`bgh b abgb uih goonnhq:
Wbcnb 7+ Duia`hioq go abgoib
Duia`i Ojok}nhchhn qucqws`ifhd,qws`if}=. qws`if }2)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;qucqws`ifhd,&Bndsogq&.Ahk}bipIbko) or wsuo
chhn oigqv`wl,qws`if}=. qws`if }2)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;oigqv`wl,Ahk}bipIbko.&Duwwose`qwo&) or wsuo
chhn qwbswqv`wl,qws`if}=. qws`if }2)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;qwbswqv`wl,Ahk}bipIbko.&Bnds&) or wsuo
`iw noifwl,qws`if }=) lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;noifwl,Ahk}bipIbko) or 20
`iw `igo|hd,qws`if }=.qws`if }2)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;`igo|hd,Ahk}bipIbko.&ndsogq&) or 2
http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=length(CompanyName)%20eq%2019http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=length(CompanyName)%20eq%2019http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=length(CompanyName)%20eq%2019http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=indexof(CompanyName,%20%27lfreds%27)%20eq%201http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=length(CompanyName)%20eq%2019http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=length(CompanyName)%20eq%2019http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=startswith(CompanyName,%20%27Alfr%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=endswith(CompanyName,%20%27Futterkiste%27)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20truehttp://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof(%27Alfreds%27,%20CompanyName)%20eq%20true -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
33/57
Ahiquk`oigh gbwhq b wsbtq go HGbwb 36
qws`if so}nbao,qws`if }=.qws`if d`ig. qws`ifso}nbao)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;so}nbao,Ahk}bipIbko. & &. &&)or &BndsogqDuwwose`qwo&
qws`if qucqws`if,qws`if}=. `iw }hq) lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;qucqws`if,Ahk}bipIbko. 2)or &ndsogq Duwwose`qwo&
qws`if qucqws`if,qws`if}=. `iw }hq. `iw noifwl)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;qucqws`if,Ahk}bipIbko. 2. 3)or &nd&
qws`if whnhvos,qws`if}=)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;whnhvos,Ahk}bipIbko) or&bndsogq duwwose`qwo&
qws`if whu}}os,qws`if}=)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;whu}}os,Ahk}bipIbko) or
&BNDSOGQ D_WWOSE@QWO&qws`if ws`k,qws`if }=) lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;ws`k,Ahk}bipIbko) or&Bndsogq Duwwose`qwo&
qws`if ahiabw,qws`if }=.qws`if }2)
lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Auqwhkosq8'd`nwos;ahiabw,ahiabw,A`wp. &. &).Ahuiwsp) or &Cosn`i. Foskbip&
Wbcnb ?+ Duia`hioq go doalb
Duia`i Ojok}nh`iw gbp,GbwoW`ko }=) lww}:((qost`aoqhgbwbhsf(Ihswlv`ig(Ihswlv`igqta(Ok}nhpooq8'd`nwos;gbp,C`swlGbwo) or
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
34/57
3
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
35/57
30
AB]W_NH
O|`qwoi tbs`hq hsfoioq go gbwhq }cn`ahq o|}uoqwhq }hs g`tosqbq oiw`gbgoq b nbahkui`gbg. wbnoq ahkh:
HGbwb Woqw Qost`ao Sobg+Hinp Ihswlv`ig Qost`ao Tbiahutos Qwsoow ]bse`if H}oi Fhtosikoiw Gbwb @i`w`bw`to Wlo A`wp hd Ogkhiwhi H}oi Gbwb Abwbnhfuo K@\ 3=2= Iowdn`| Ahgoibko Gbnnbq
Bq ahkh tbs`hq oiwhsihq go goqbsshnnh ruo qh}hswbi nb asoba`i go hsfoioq HGbwbahkh:
K`ashqhdw IOW Dsbkovhse 1? b wsbtq go VAD Gbwb Qost`aoq Dsbkovhse K`ashqhdw IOW Dsbkovhse 7= b wsbtq go VAD Gbwb Qost`aoq Dsbkovhse Qlbso}h`iw 3=2= ruo o|}hio whgb nb `idhskba`i b wsbtq go HGbwb @CK VocQ}loso QRN Bzuso V`ighvq Bzuso Qwhsbfo QRN Qostos So}hsw`if Qost`aoq
Nh ruo tbkhq b tos oq ui ojok}nh go asoba`i go ui qost`a`h HGbwb ahi K`ashqhdwT`qubn Qwug`h IOW 3=2= p IOW Dsbkovhse 7=. ahi nb cbqo go gbwhq go ojok}nhBgtoiwusoVhseqNW3==
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
36/57
1= Ahkoizbigh ahi HGbwb
]bsb onnh cbqwb ahi asobs ui iuoth }shpoawh BQ]IOW Voc B}}n`abw`hi }bsblhq}ogbs on qost`a`h Gbgh ruo tbkhq b so}soqoiwbs iwofsbkoiwo nb cbqo go gbwhqBgtoiwusoVhseqNW3==< nh }s`kosh ruo tbkhq b lbaos oq asobs ui khgonh go oiw`gbgoqb wsbtq go BGHIOW Oiw`wp Dsbkovhse. bbg`oigh on onokoiwh BGHIOW Oiw`wpGbwb Khgon:
D`fusb 2+ Asoba`i go ui khgonh go gbwhq ahi Oiw`wp Dsbkovhse
_ib toz qonoaa`hibgb nb }nbiw`nnb o `ig`abgh on ihkcso foiosbsokhq on khgonh b}bsw`s go uib cbqo go gbwhq
D`fusb 3+ Bq`qwoiwo }bsb foiosba`i gon khgonh b }bsw s go uib cbqo go gbwhq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
37/57
]bqh b }bqh: asoba`i go ui qost`a`h HGbwb 12
Asobkhq p qonoaa`hibkhq nb abgoib go ahio|`i b BgtoiwusoVhseqNW3==< pbnkbaoibkhq nb abgoib go ahio|`i oi on bsal`th Voc)ahid`f
D`fusb 1+ ]bqh }bsb god`i`s nb abgoib go ahio|`i
Iwoqo ruo nb abgoib go ahio|`i b nb oiw`gbg t`oio gowosk`ibgb }hs nb god`i`a`igon AQGN:
kowbgbwb;soq:((*(Khgon2aqgn~soq:((*(Khgon2qqgn~soq:((*(Khgon2kqn5}sht`gos;QpqwokGbwbQrnAn`oiw5}sht`gos ahiioaw`hi qws`if;#GbwbQhusao;NBW@W_GO+O47==5@i`w`bn Abwbnhf;BgtoiwusoVhseqNW3==
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
38/57
13 Ahkoizbigh ahi HGbwb
D`fusb 7+ Qonoaa`i go wbcnbq
P d`ibnkoiwo woigsokhq on khgonh go oiw`gbgoq bfsofbgh b iuoqwsh }shpoawh
D`fusb ?+ On khgonh go gbwhq ruo tbkhq b o|}hios
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
39/57
]bqh b }bqh: asoba`i go ui qost`a`h HGbwb 11
Blhsb lbp ruo o|}hios on khgonh b ui qost`a`h p }bsb onnh bbg`khq ui iuothonokoiwh VAD Gbwb Qost`ao:
D`fusb 4+ @iqoswbkhq ui iuoth qost`a`h go gbwhq VAD
]hs nw`kh ahid`fusbkhq on qost`a`h }bsb ruo lbfb uqh gon khgonh go oiw`gbgoqfoiosbgh biwos`hskoiwo:
}ucn`a anbqq BgtoiwusoVhseqQost`ao :GbwbQost`ao>BgtoiwusoVhseqNW3==
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
40/57
17 Ahkoizbigh ahi HGbwb
D`fusb 6+ On qost`a`h }ush duia`hibigh oi on ibtofbghs
B ahiw`iuba`i tosokhq akh ahiquk`s oqwo qost`a`h goqgo g`tosqhq an`oiwoq
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
41/57
1?
AB]W_NH
Go nb k`qkb dhskb ruo woiokhq lossbk`oiwbq }bsb nb foiosba`i go hsfoioq HGbwb.g`q}hiokhq go knw`}noq lossbk`oiwbq go goqbsshnnh b iuoqwsh bnabiao }bsb nbkbi`}unba`i oi on nbgh an`oiwo go oqhq gbwhq. ahkh }hs ojok}nh:
Aubnru`os o|}nhsbghs Voc K`ashqhdw IOW Dsbkovhse 1?2 p 7= Q`ntosn`flw 1 p 7 V`ighvq ]lhio 6 Jbtb JbtbQas`}w ]L] BJB\ O|aon 3=2= ]hvos]`thw N@IR]bg
Ihwb: ]hgokhq oiahiwsbs on ag`fh duoiwo go nbq n`csosbq an`oiwoq }bsb HGbwbgo Q`ntosn`flw 1= p IOW Dsbkovhse 1? Q]2 oi on q`w`hlww}:((hgbwbahgo}no|ahk. cbjh n`aoia`b B}balo 3=
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh
go HGbwb
?
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
42/57
14 Ahkoizbigh ahi HGbwb
D`fusb 2+ N`qwbgh go lossbk`oiwbq g`q}hi`cnoq oi HGbwbhsf
B ahiw`iuba`i tosokhq bnfuihq ojok}nhq go nbq n`csosbq an`oiwo ruo oqwibawubnkoiwo g`q}hi`cnoq }bsb HGbwb
2+ V@IGHVQ ]LHIO 6HGbwb oq nb }nbwbdhskb go qost`a`hq go gbwhq }bsb nbq b}n`aba`hioq V`ighvq ]lhio
6 ]hgs oiahiwsbs kq `idhskba`i oiKhc`nI_F Qos`oq
D`fusb 3+ Ojok}nh go ahiqukh go HGbwb goqgo V`ighvq ]lhio 6
http://www.mobilenugseries.com/http://www.mobilenugseries.com/http://www.mobilenugseries.com/http://www.mobilenugseries.com/ -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
43/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 16
3+ OJOK]NH AHI VAD]bsb asobs on an`oiwo h }sh|p bn qost`a`h go gbwhq }hgokhq uw`n`zbs on }sh}`h T`qubn
Qwug`h IOW 3==
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
44/57
1
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
45/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 10
gbwbFs`g2@wokqQhusao ; ruospWhN`qw,)5{
Iwoqo ruo q` bfsofbkhq ui }uiwh go `iwossu}a`i oi w`ok}h go go}usba`i. on
hcjowh ruosp ahiwoigs nb ahitoia`i _S@ oru`tbnoiwo b nbq h}osba`hioq go d`nwsbgh phsgoiba`i t`qwbq biwos`hskoiwo
D`fusb 4+ Nb _S@ HGbwb soqunwbiwo go nb ahiqunwb
Nb b}n`aba`i wsbq nb ojoaua`i w`oio on q`fu`oiwo bq}oawh:
D`fusb 6+ Bq}oawh go nb b}n`aba`i V]D
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
46/57
7= Ahkoizbigh ahi HGbwb
1+ OJOK]NH AHI JR_OSPHwsh ojok}nh gokhqwsbw`th oq nb ahiqunwb go oqwo w`}h go qost`a`hq kog`biwo
JbtbQas`}w. kq ahiasowbkoiwo uqbigh nb c`cn`hwoab jRuospOi on q`fu`oiwo ag`fh qo sobn`zb uib nnbkbgb bn qost`a`h go gbwhq hcwoi`oighi`abkoiwo nhq ghq }s`koshq ,qoiwoia`b 'wh}) p qo sobn`zb qu so}soqoiwba`i cq`ab oi ono|}nhsbghs
>"GHAWP]O lwkn ]_CN@A #+((V1A((GWG \LWKN 2= Wsbiq`w`hibn((OI##lww}:((vvvv1hsf(WS(|lwkn2(GWG(|lwkn2+wsbiq`w`hibngwg#9
>lwkn |kniq;#lww}:((vvvv1hsf(2000(|lwkn#9>lobg `g;#Lobg2# suibw;#qostos#9
>w`wno9HGbwb ahi JRuosp>(w`wno9>qas`}w qsa;#(Qas`}wq(jruosp+213jq# wp}o;#wo|w(jbtbqas`}w#9>(qas`}w9
>(lobg9>chgp9
>qas`}w wp}o;#wo|w(jbtbqas`}w#9',duiaw`hi absfbigh,)
',#!dhh#)wo|w,#absfbigh#)5tbs usn ;
#lww}:((nhabnlhqw:23?4=(BgtoiwusoVhseqQost`aoqta(]shguaw8'wh};3#5'fowJQHI,usn. duiaw`hi ,soqunw)
'obal,soqunwg. duiaw`hi ,`. `wok) ',&!}shguawq&)b}}oig,&>g`t `g;L& % ` % &9>}9 +++
9 ]shguaw `idh>(}9>(g`t9&)5',&!L& % `)b}}oig,&>}9 ]shguaw@G: & %
`wok]shguaw@G % &>(}9&)5',&!L& % `)b}}oig,&>}9 Ibko: & % `wokIbko %
&>(}9&)5',&!L& % `)b}}oig,&>}9 ]shgIukcos: & %
`wok]shguawIukcos % &>(}9&)5{)5{)5
{)5>(qas`}w9>}9Ojok}nh HGbwb>(}9
>g`t `g;#}shguawq#9>(g`t9
>(chgp9>(lwkn9
On soqunwbgh go ojoauwbs on ag`fh biwos`hs oi uib }f`ib LWKN oq on q`fu`oiwo:
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
47/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 72
D`fusb
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
48/57
73 Ahkoizbigh ahi HGbwb
D`fusb 2=+ Oinbzbs goqgo ]hvos]`thw ahi on qost`a`h go gbwhq HGbwb
B ahiw`iuba`i qonoaa`hibkhq nbq Oiwsbgbq ruo ruosokhq wsbwbs ahi ]hvos]`thw:
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
49/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 71
D`fusb 22+ Qonoaa`i go wbcnbq goqgo on hs`foi HGbwb
P ahkoizbs nb `k}hswba`i go gbwhq:
D`fusb 23+ @k}hswba`i go gbwhq oi ]hvos]`thw
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
50/57
77 Ahkoizbigh ahi HGbwb
D`ibnkoiwo woigsokhq whghq nhq gbwhq go nbq Oiwsbgbq so}bsw`gbq oi Lhjbq gon n`csh]hvos]`thw
D`fusb 21+ Gbwhq `k}hswbghq oi ]hvos]`thw p n`qwhq }bsb bibn`zbs
?+QRN BZ_SO
_ib go nbq ihtogbgoq ruo }soqoiw K`ashqhdw oi on }bqbgh K@\3=2= ruo wuth nufbsoi Nbq Tofbq duo nb ahk}bw`c`n`gbg go aubnru`os cbqo go gbwhq QRN Bzuso }bsb qoso|}uoqwb ahkh HGbwb Oq goa`s ruo q` lhq}ogbkhq uib cbqo go gbwhq QRN Bzusowoigsokhq nb h}a`i go o|}hiosnb ahkh qost`a`h HGbwb. p q`i ioaoq`gbg go woios ruoasobs on qost`a`h. bnfh ruo q` lbaokhq ahi hwshq khgonh go gbwhq p ruo lokhq t`qwhbiwos`hskoiwo
Nh i`ah ruo gocokhq lbaos oq t`q`wbsHGbwb Qost`ao ]hswbnp qofu`s on bq`qwoiwo.`ig`abigh on qost`ghs p uqubs`h go bgk`i`qwsba`i ]hqwos`hskoiwo qonoaa`hibkhq nbcbqo go gbwhq ruo woiokhq o|}uoqwb oi Bzuso p lbc`n`wbkhq HGbwb kog`biwo nb h}a`i
Oibcno HGbwbOi oqo khkoiwh qo foiosbs ui Oig]h`iw }bsb on Qost`a`h go Gbwhq p }hgsokhqqonoaa`hibs(asobs nhq uqubs`hq ruo woigsi }osk`qhq go baaoqh bn Oig]h`iw
https://www.sqlazurelabs.com/https://www.sqlazurelabs.com/https://www.sqlazurelabs.com/https://www.sqlazurelabs.com/ -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
51/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 7?
D`fusb 27+ Ahid`fusba`i go ui hs`foi HGbwb }bsb QRN Bzuso
4+ N@IR]BGHwsh an`oiwo g`q}hi`cno }bsb wsbcbjbs ahi HGbwb oq N@IR]bg. tosq`i 7 ]bsb
ok}ozbs b ahiquk`s gbwhq go ui qost`a`h HGbwb cbqwb ahi ahid`fusbs nb ahio|`iq`fu`oigh nhq }bqhq o|}n`abghq b ahiw`iuba`i
Oi }s`kos nufbs bbg`khq uib iuotb ahio|`i p qonoaa`hibkhq VAD Gbwb Qost`ao}bsb oqwbcnoaos on ahiwo|wh gon hs`foi:
http://www.linqpad.net/http://www.linqpad.net/http://www.linqpad.net/ -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
52/57
74 Ahkoizbigh ahi HGbwb
D`fusb 2?+ God`i`a`i gon ahiwo|wh go hs`foi
@ig`abkhq nb _S@ gon qost`a`h o `ig`abkhq ruo qo wsbwb go ui Qost`a`h go GbwhqAhid`fusbkhq on }sh|p b }sh}`b onoaa`i:
D`fusb 24+ Ahid`fusba`i gon }sh|p
P d`ibnkoiwo ojoauwbkhq nbq ahiqunwbq N@IR ruo ruosbkhq qhcso g`alh hs`foi gogbwhq:
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
53/57
Ojok}nhq kunw`+}nbwbdhskb go ahiqukh go HGbwb 76
D`fusb 26+ Ahiqunwbq g`soawbq ahiwsb HGbwb goqgo N@IR]bg
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
54/57
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
55/57
70
AB]W_NH
HGbwb oq q`i gugb uib duoswo b}uoqwb }hs }bswo go K`ashqhdw }bsb nb kbi`}unba`igo gbwhq b wsbtq go h}osba`hioq AS_G w`}bgbq. ahiqwsu`gh qhcso oqwigbsoq go@iwosiow Qu duwush oqw oi kbih go nhq dbcs`abiwoq(ok}soqbq. bq ahkh go nb ahkui`gbgruo ru`osb bgh}wbsnh cbjh nb }shkoqb go ag`fh bc`oswh HQQ ,H}oi Qhusao Qhdwvbso)+Oi oqwo kbiubn no lokhq wsbwbgh go cs`igbs uib `iwshguaa`i qud`a`oiwo ahkh }bsb gbsnhq }s`koshq }bqhq oi oqwb woaihnhfb. ahi nhq ahiao}whq wos`ahq qud`a`oiwoq. bq ahkhahi bnfuihq ojok}nhq }saw`ahq go uqh go nhq ruo }bsw`s
HGbwb no soqunwbs go fsbi uw`n`gbg oi kunw`wug go oqaoibs`hq }saw`ahq goiwsh go nbqok}soqbq p oi bsru`woawusbq g`qws`cu`gbq p }bsb @iwosiow
2+ SODOSOIA@BQ _W@N@ZBGBQNbq wbcnbq go sodosoia`b p bnfuibq `kfoioq khqwsbgbq oi oqwo bswaunh lbi q`gh
o|wsbgbq golww}:((vvvhgbwbhsf Oi bnfuihq abqhq qo lb h}wbgh }hs nb wsbguaa`igon ahiwoi`gh go bnfuibq wbcnbq k`oiwsbq ruo oi hwshq qo lb h}wbgh }hs gojbs nhq tbnhsoqoi `ifnq hs`f`ibnoq }bsb ih asobs ahiduq`hioq p dba`n`wbs bn noawhs nb ahk}soq`i gowsk`ihq uw`n`zbghq }hs HGbwb
Nbq gokq sodosoia`bq uw`n`zbgbq lbi q`gh:
H}oi Gbwb ]shwhahn Ghaukoiwbw`hi:lww}:((vvvhgbwbhsf(gotonh}osq(}shwhahnq
H}oi Gbwb ]shwhahn cp o|bk}no go Als`q Qonnqlww}:((kqgik`ashqhdwahk(oi+uq(n`csbsp(dd76
-
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
56/57
?= Ahkoizbigh ahi HGbwb
3+ BNF_IBQ SODOSOIA@BQ @IWOSOQBIWOQB ahiw`iuba`i qo hdsoaoi bnfuihq oinbaoq bg`a`hibnoq ruo no }osk`w`si }shduig`zbs
oi on uqh go HGbwb goqgo g`qw`iwhq oiwhsihq p noifubjoq go }shfsbkba`i: Asobw`if bi HGbwb B]@ dhs QwbaeHtosdnhv `ianug`if \KN big JQHI `i 1=k`iuwoq. }hs Qahww Lbiqonkbi
HGbwb `iwosh}osbc`n`wp v`wl IOW. Jbtb. ]L]. `]lhio big khso. oi on cnhf go`iwosh}osbc`n`gbg go K`ashqhdw
]shgua`if big ahiquk`if HGbwb doogq: Bi oig+wh+oig o|bk}no. }hs Jhi _gonn
Sows`ot`if Gbwb v`wl wlo HGbwb QGE dhs ]L]. }hs Cs`bi Qvbi
Otosp Qlbso]h`iw 3=2= qostos `q b Gbwb Qost`aoq qostos. }hs ]bcnh Abqwsh
HGbwb big Sucp. }hs E Qahww Bnnoi
Wbkc`i }uogo oalbsno ui t`qwbzh b nb `iwosoqbiwo lossbk`oiwb Q`ntosn`flw HGbwbO|}nhsos. ruo }osk`wo o|bk`ibs duoiwoq go gbwhq HGbwb g`soawbkoiwo goqgo onibtofbghs
http://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspxhttp://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspxhttp://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspxhttp://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspxhttp://blogs.msdn.com/b/interoperability/archive/2010/03/16/odata-interoperability-with-net-java-php-iphone-and-more.aspxhttp://blogs.msdn.com/b/interoperability/archive/2010/03/16/odata-interoperability-with-net-java-php-iphone-and-more.aspxhttp://blogs.msdn.com/b/interoperability/archive/2010/03/16/odata-interoperability-with-net-java-php-iphone-and-more.aspxhttp://blog.jonudell.net/2010/02/09/producing-and-consuming-odata-feeds-an-end-to-end-example/http://blog.jonudell.net/2010/02/09/producing-and-consuming-odata-feeds-an-end-to-end-example/http://blog.jonudell.net/2010/02/09/producing-and-consuming-odata-feeds-an-end-to-end-example/http://blogs.msdn.com/b/brian_swan/archive/2010/03/18/using-the-odata-sdk-for-php.aspxhttp://blogs.msdn.com/b/brian_swan/archive/2010/03/18/using-the-odata-sdk-for-php.aspxhttp://blogs.msdn.com/b/brian_swan/archive/2010/03/18/using-the-odata-sdk-for-php.aspxhttp://blogs.msdn.com/b/pablo/archive/2009/10/19/every-sharepoint-2010-server-is-a-data-services-server.aspxhttp://blogs.msdn.com/b/pablo/archive/2009/10/19/every-sharepoint-2010-server-is-a-data-services-server.aspxhttp://blogs.msdn.com/b/pablo/archive/2009/10/19/every-sharepoint-2010-server-is-a-data-services-server.aspxhttp://odetocode.com/Blogs/scott/archive/2010/07/11/odata-and-ruby.aspxhttp://odetocode.com/Blogs/scott/archive/2010/07/11/odata-and-ruby.aspxhttp://odetocode.com/Blogs/scott/archive/2010/07/11/odata-and-ruby.aspxhttp://www.silverlight.net/content/samples/odataexplorer/http://www.silverlight.net/content/samples/odataexplorer/http://www.silverlight.net/content/samples/odataexplorer/http://www.silverlight.net/content/samples/odataexplorer/http://www.silverlight.net/content/samples/odataexplorer/http://odetocode.com/Blogs/scott/archive/2010/07/11/odata-and-ruby.aspxhttp://blogs.msdn.com/b/pablo/archive/2009/10/19/every-sharepoint-2010-server-is-a-data-services-server.aspxhttp://blogs.msdn.com/b/brian_swan/archive/2010/03/18/using-the-odata-sdk-for-php.aspxhttp://blog.jonudell.net/2010/02/09/producing-and-consuming-odata-feeds-an-end-to-end-example/http://blogs.msdn.com/b/interoperability/archive/2010/03/16/odata-interoperability-with-net-java-php-iphone-and-more.aspxhttp://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspxhttp://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspx -
7/23/2019 Whitepaper - Comenzando Con OData - JM Torres - Krasis Press
57/57
Wo `iwosoqb oqwo n`csh8Ahk}sb on n`csh onoawsi`ah oi iuoqwsb w`oigb: lww}:((qlh})abk}uqkt})ahk
Oq}oa`bn`qwbq oi dhskba`i hin`io p n`cshq
go woaihnhfbq K`ashqhdw)
+ Oi dhskbwh ]GD
+ Q`i GSK
+ @k}s`k`cno
+ Cuqab oi on ahiwoi`gh