.NET Webservice for MySQL
0 likes444 views
MySQL PowerGroup Tech Seminar (2015.2) - 7. .NET Webservice for MySQL (by 豕讌) - URL : cafe.naver.com/mysqlpg
.NET Webservice for MySQL
- 1. .net webservice for mysql .NET MySQL 蠍 2015.08.29 豕讌 1
- 2. 2 MSSQL in/out XML type 語襦 覦 襦 企 Parsing
- 3. 3 .NET Reflection Parameter Bind Parameter 覲蟆曙 襷る 貊 覿ｸ, client web database (procedure ) 蟾讌 class襦 蟯襴
- 4. 4 Information_schema 螻朱 譟壱? CBT 危 information_schema. ROUTINES 譟壱 磯ジ tmp_table 螻朱 覦蟆
- 5. 5 Information_schema 螻朱 譟壱? Check Parameters Option Check Parameter = True 語 螳 name 襷 襷朱 OK. 譴讌 讌襷 MySQL Connector 螳 企 parameter binding 企朱 襷る information schema 譟壱覃伎 tmp table 焔レ Check Parameter = False 襦 Parameter 螳 覓朱 螳 襷讌 Exception 覦襦 !
- 6. 6 Information_schema 螻朱 譟壱? Check Parameters Option
- 7. 7 ROW_COUNT() (Workbench Connection vs MySQL Connector .NET) affect_row vs matched_row affect_row : CASE WHEN 譟郁唄 , れ Update 螳 殊企 row matched_row : WHERE 譟郁唄 襷譟燕 row
- 8. 8 affect_row vs matched_row SUCCESS Case FAIL Case 襦 ROW_COUNT() 螳 affected_row 襦 讌螻, 豌危蟇伎 れ一危瑚唄螳 襷讌 蟆曙 IF 覓語 伎ろ 豌襴 (れ 2螳讌 rune 覈 一危 讌 ) on Workbench Connection ROW_COUNT() (Workbench Connection vs MySQL Connector .NET)
- 9. 9 affect_row vs matched_row 蟆螻 襴, IF 覓 豌危螳 讌 , Result 0 朱 襴企螻 れ gold 讀螳 on MySQL Connector .NET ROW_COUNT() (Workbench Connection vs MySQL Connector .NET)
- 10. 10 Unexpected result on ROW_COUNT() Connection String option 磯 MySQL .NET Connector ろ Procedure 企 ROW_COUNT() 螳 affected_row matched_row 襦 語 Default Use Affected Rows=False matched_row 企濠化一 UPDATE ROW_COUNT 豌危 譯殊伎狩. Use Affected Rows=True affected_row ROW_COUNT() (Workbench Connection vs MySQL Connector .NET)
- 11. 11