%PDF-1.4
5 0 obj
<< /S /GoTo /D (section*.1) >>
endobj
8 0 obj
(Contents)
endobj
9 0 obj
<< /S /GoTo /D (chapter*.3) >>
endobj
12 0 obj
(Legal Notice)
endobj
13 0 obj
<< /S /GoTo /D (chapter*.4) >>
endobj
16 0 obj
(License)
endobj
17 0 obj
<< /S /GoTo /D (chapter.1) >>
endobj
20 0 obj
(Introduction)
endobj
21 0 obj
<< /S /GoTo /D (section.1.1) >>
endobj
24 0 obj
(Overview)
endobj
25 0 obj
<< /S /GoTo /D (section.1.2) >>
endobj
28 0 obj
(What's covered here)
endobj
29 0 obj
<< /S /GoTo /D (section.1.3) >>
endobj
32 0 obj
(Support)
endobj
33 0 obj
<< /S /GoTo /D (section.1.4) >>
endobj
36 0 obj
(Disclaimer)
endobj
37 0 obj
<< /S /GoTo /D (chapter.2) >>
endobj
40 0 obj
(The Big Picture)
endobj
41 0 obj
<< /S /GoTo /D (section.2.1) >>
endobj
44 0 obj
(Introduction)
endobj
45 0 obj
<< /S /GoTo /D (section.2.2) >>
endobj
48 0 obj
(What does it do?)
endobj
49 0 obj
<< /S /GoTo /D (section.2.3) >>
endobj
52 0 obj
(How does it work?)
endobj
53 0 obj
<< /S /GoTo /D (section.2.4) >>
endobj
56 0 obj
(Is SQLMap the best choice for my project?)
endobj
57 0 obj
<< /S /GoTo /D (chapter.3) >>
endobj
60 0 obj
(Working with Data Maps)
endobj
61 0 obj
<< /S /GoTo /D (section.3.1) >>
endobj
64 0 obj
(Introduction)
endobj
65 0 obj
<< /S /GoTo /D (section.3.2) >>
endobj
68 0 obj
(What's in a Data Map definition file, anyway?)
endobj
69 0 obj
<< /S /GoTo /D (section.3.3) >>
endobj
72 0 obj
(Mapped Statements)
endobj
73 0 obj
<< /S /GoTo /D (subsection.3.3.1) >>
endobj
76 0 obj
(Statement Types)
endobj
77 0 obj
<< /S /GoTo /D (subsection.3.3.2) >>
endobj
80 0 obj
(Stored Procedures)
endobj
81 0 obj
<< /S /GoTo /D (section.3.4) >>
endobj
84 0 obj
(The SQL)
endobj
85 0 obj
<< /S /GoTo /D (subsection.3.4.1) >>
endobj
88 0 obj
(Escaping XML symbols)
endobj
89 0 obj
<< /S /GoTo /D (subsection.3.4.2) >>
endobj
92 0 obj
(Auto-Generated Keys)
endobj
93 0 obj
<< /S /GoTo /D (subsection.3.4.3) >>
endobj
96 0 obj
(<generate> tag)
endobj
97 0 obj
<< /S /GoTo /D (section.3.5) >>
endobj
100 0 obj
(Statement-type Element Attributes)
endobj
101 0 obj
<< /S /GoTo /D (subsection.3.5.1) >>
endobj
104 0 obj
(id attribute)
endobj
105 0 obj
<< /S /GoTo /D (subsection.3.5.2) >>
endobj
108 0 obj
(parameterMap attribute)
endobj
109 0 obj
<< /S /GoTo /D (subsection.3.5.3) >>
endobj
112 0 obj
(parameterClass attribute )
endobj
113 0 obj
<< /S /GoTo /D (subsection.3.5.4) >>
endobj
116 0 obj
(resultMap attribute)
endobj
117 0 obj
<< /S /GoTo /D (subsection.3.5.5) >>
endobj
120 0 obj
(resultClass attribute)
endobj
121 0 obj
<< /S /GoTo /D (subsection.3.5.6) >>
endobj
124 0 obj
(listClass attribute)
endobj
125 0 obj
<< /S /GoTo /D (subsection.3.5.7) >>
endobj
128 0 obj
(cacheModel attribute)
endobj
129 0 obj
<< /S /GoTo /D (subsection.3.5.8) >>
endobj
132 0 obj
(extends attribute)
endobj
133 0 obj
<< /S /GoTo /D (chapter.4) >>
endobj
136 0 obj
(Parameter Maps and Inline Parameters)
endobj
137 0 obj
<< /S /GoTo /D (section.4.1) >>
endobj
140 0 obj
(Parameter Map)
endobj
141 0 obj
<< /S /GoTo /D (subsection.4.1.1) >>
endobj
144 0 obj
(<parameterMap> attributes)
endobj
145 0 obj
<< /S /GoTo /D (section.4.2) >>
endobj
148 0 obj
(<parameter> Elements)
endobj
149 0 obj
<< /S /GoTo /D (subsection.4.2.1) >>
endobj
152 0 obj
(property attribute)
endobj
153 0 obj
<< /S /GoTo /D (subsection.4.2.2) >>
endobj
156 0 obj
(direction attribute)
endobj
157 0 obj
<< /S /GoTo /D (subsection.4.2.3) >>
endobj
160 0 obj
(column attribute)
endobj
161 0 obj
<< /S /GoTo /D (subsection.4.2.4) >>
endobj
164 0 obj
(dbType attribute)
endobj
165 0 obj
<< /S /GoTo /D (subsection.4.2.5) >>
endobj
168 0 obj
(type attribute)
endobj
169 0 obj
<< /S /GoTo /D (subsection.4.2.6) >>
endobj
172 0 obj
(nullValue attribute)
endobj
173 0 obj
<< /S /GoTo /D (subsection.4.2.7) >>
endobj
176 0 obj
(size attribute)
endobj
177 0 obj
<< /S /GoTo /D (subsection.4.2.8) >>
endobj
180 0 obj
(precision attribute)
endobj
181 0 obj
<< /S /GoTo /D (subsection.4.2.9) >>
endobj
184 0 obj
(scale attribute)
endobj
185 0 obj
<< /S /GoTo /D (subsection.4.2.10) >>
endobj
188 0 obj
(typeHandler attribute)
endobj
189 0 obj
<< /S /GoTo /D (section.4.3) >>
endobj
192 0 obj
(Inline Parameter Maps)
endobj
193 0 obj
<< /S /GoTo /D (section.4.4) >>
endobj
196 0 obj
(Standard Type Parameters)
endobj
197 0 obj
<< /S /GoTo /D (section.4.5) >>
endobj
200 0 obj
(Array Type Parameters)
endobj
201 0 obj
<< /S /GoTo /D (chapter.5) >>
endobj
204 0 obj
(Result Maps)
endobj
205 0 obj
<< /S /GoTo /D (section.5.1) >>
endobj
208 0 obj
(Extending resultMaps)
endobj
209 0 obj
<< /S /GoTo /D (section.5.2) >>
endobj
212 0 obj
(<resultMap> attributes)
endobj
213 0 obj
<< /S /GoTo /D (subsection.5.2.1) >>
endobj
216 0 obj
(id attribute)
endobj
217 0 obj
<< /S /GoTo /D (subsection.5.2.2) >>
endobj
220 0 obj
(class attribute)
endobj
221 0 obj
<< /S /GoTo /D (subsection.5.2.3) >>
endobj
224 0 obj
(extends attribute)
endobj
225 0 obj
<< /S /GoTo /D (section.5.3) >>
endobj
228 0 obj
(<result> Elements)
endobj
229 0 obj
<< /S /GoTo /D (subsection.5.3.1) >>
endobj
232 0 obj
(property attribute)
endobj
233 0 obj
<< /S /GoTo /D (subsection.5.3.2) >>
endobj
236 0 obj
(column attribute)
endobj
237 0 obj
<< /S /GoTo /D (subsection.5.3.3) >>
endobj
240 0 obj
(columnIndex attribute)
endobj
241 0 obj
<< /S /GoTo /D (subsection.5.3.4) >>
endobj
244 0 obj
(dbType attribute)
endobj
245 0 obj
<< /S /GoTo /D (subsection.5.3.5) >>
endobj
248 0 obj
(type attribute)
endobj
249 0 obj
<< /S /GoTo /D (subsection.5.3.6) >>
endobj
252 0 obj
(resultMapping attribute)
endobj
253 0 obj
<< /S /GoTo /D (subsection.5.3.7) >>
endobj
256 0 obj
(nullValue attribute)
endobj
257 0 obj
<< /S /GoTo /D (subsection.5.3.8) >>
endobj
260 0 obj
(select attribute)
endobj
261 0 obj
<< /S /GoTo /D (subsection.5.3.9) >>
endobj
264 0 obj
(lazyLoad attribute)
endobj
265 0 obj
<< /S /GoTo /D (subsection.5.3.10) >>
endobj
268 0 obj
(typeHandler attribute)
endobj
269 0 obj
<< /S /GoTo /D (section.5.4) >>
endobj
272 0 obj
(Custom Type Handlers)
endobj
273 0 obj
<< /S /GoTo /D (section.5.5) >>
endobj
276 0 obj
(Implicit Result Maps)
endobj
277 0 obj
<< /S /GoTo /D (section.5.6) >>
endobj
280 0 obj
(Primitive Results \(i.e. String, Integer, Boolean\))
endobj
281 0 obj
<< /S /GoTo /D (section.5.7) >>
endobj
284 0 obj
(Maps with ResultMaps)
endobj
285 0 obj
<< /S /GoTo /D (section.5.8) >>
endobj
288 0 obj
(Complex Properties)
endobj
289 0 obj
<< /S /GoTo /D (section.5.9) >>
endobj
292 0 obj
(Avoiding N+1 Selects \(1:1\))
endobj
293 0 obj
<< /S /GoTo /D (section.5.10) >>
endobj
296 0 obj
(Complex Collection Properties)
endobj
297 0 obj
<< /S /GoTo /D (section.5.11) >>
endobj
300 0 obj
(Avoiding N+1 Select Lists \(1:M and M:N\))
endobj
301 0 obj
<< /S /GoTo /D (subsection.5.11.1) >>
endobj
304 0 obj
(1:N \046 M:N Solution?)
endobj
305 0 obj
<< /S /GoTo /D (section.5.12) >>
endobj
308 0 obj
(Composite Keys or Multiple Complex Parameters Properties)
endobj
309 0 obj
<< /S /GoTo /D (chapter.6) >>
endobj
312 0 obj
(Cache Models)
endobj
313 0 obj
<< /S /GoTo /D (section.6.1) >>
endobj
316 0 obj
(Cache Implementation)
endobj
317 0 obj
<< /S /GoTo /D (subsection.6.1.1) >>
endobj
320 0 obj
(Least Recently Used [LRU] Cache)
endobj
321 0 obj
<< /S /GoTo /D (subsection.6.1.2) >>
endobj
324 0 obj
(FIFO Cache)
endobj
325 0 obj
<< /S /GoTo /D (chapter.7) >>
endobj
328 0 obj
(Dynamic SQL)
endobj
329 0 obj
<< /S /GoTo /D (chapter.8) >>
endobj
332 0 obj
(Installation and Setup)
endobj
333 0 obj
<< /S /GoTo /D (section.8.1) >>
endobj
336 0 obj
(Introduction)
endobj
337 0 obj
<< /S /GoTo /D (section.8.2) >>
endobj
340 0 obj
(Installing the DataMapper for PHP)
endobj
341 0 obj
<< /S /GoTo /D (subsection.8.2.1) >>
endobj
344 0 obj
(Setup the Distribution)
endobj
345 0 obj
<< /S /GoTo /D (subsection.8.2.2) >>
endobj
348 0 obj
(Add XML file items)
endobj
349 0 obj
<< /S /GoTo /D (section.8.3) >>
endobj
352 0 obj
(Configuring the DataMapper for PHP)
endobj
353 0 obj
<< /S /GoTo /D (subsection.8.3.1) >>
endobj
356 0 obj
(DataMapper clients)
endobj
357 0 obj
<< /S /GoTo /D (section.8.4) >>
endobj
360 0 obj
(DataMapper Configuration File \(SqlMap.config\))
endobj
361 0 obj
<< /S /GoTo /D (section.8.5) >>
endobj
364 0 obj
(DataMapper Configuration Elements)
endobj
365 0 obj
<< /S /GoTo /D (subsection.8.5.1) >>
endobj
368 0 obj
(<properties> attributes)
endobj
369 0 obj
<< /S /GoTo /D (subsection.8.5.2) >>
endobj
372 0 obj
(<property> element and attributes)
endobj
373 0 obj
<< /S /GoTo /D (subsection.8.5.3) >>
endobj
376 0 obj
(The <typeHandler> Element)
endobj
377 0 obj
<< /S /GoTo /D (subsection.8.5.4) >>
endobj
380 0 obj
(The <provider> element and attribute)
endobj
381 0 obj
<< /S /GoTo /D (subsection.8.5.5) >>
endobj
384 0 obj
(The <datasource> element and attributes)
endobj
385 0 obj
<< /S /GoTo /D (subsection.8.5.6) >>
endobj
388 0 obj
(The <sqlMap> Element)
endobj
389 0 obj
<< /S /GoTo /D (chapter.9) >>
endobj
392 0 obj
(Using SQLMap PHP DataMapper)
endobj
393 0 obj
<< /S /GoTo /D (section.9.1) >>
endobj
396 0 obj
(Building a TSqlMapper instance)
endobj
397 0 obj
<< /S /GoTo /D (subsection.9.1.1) >>
endobj
400 0 obj
(Multiple Databases)
endobj
401 0 obj
<< /S /GoTo /D (subsection.9.1.2) >>
endobj
404 0 obj
(TDomSqlMapBuilder Configuration Options)
endobj
405 0 obj
<< /S /GoTo /D (section.9.2) >>
endobj
408 0 obj
(Exploring the SQLMap PHP DataMapper API through the TSqlMapper)
endobj
409 0 obj
<< /S /GoTo /D (subsection.9.2.1) >>
endobj
412 0 obj
(Insert, Update, Delete)
endobj
413 0 obj
<< /S /GoTo /D (subsection.9.2.2) >>
endobj
416 0 obj
(QueryForObject)
endobj
417 0 obj
<< /S /GoTo /D (subsection.9.2.3) >>
endobj
420 0 obj
(QueryForList)
endobj
421 0 obj
<< /S /GoTo /D (subsection.9.2.4) >>
endobj
424 0 obj
(QueryForPagedList)
endobj
425 0 obj
<< /S /GoTo /D (subsection.9.2.5) >>
endobj
428 0 obj
(QueryForMap)
endobj
429 0 obj
<< /S /GoTo /D (subsection.9.2.6) >>
endobj
432 0 obj
(Transaction)
endobj
433 0 obj
<< /S /GoTo /D (section.9.3) >>
endobj
436 0 obj
(Coding Examples)
endobj
437 0 obj
<< /S /GoTo /D [438 0 R /FitH ] >>
endobj
440 0 obj <<
/Length 374
/Filter /FlateDecode
>>
stream
xڍRJ@}Wc3{cTChclmHkſwҍh a9gB" "S%1䬇 =C`@wAh=B@дࣼw8Pg"4 0!*TU|bUp.)h
| 