{"id":1557,"date":"2014-04-22T08:42:28","date_gmt":"2014-04-22T07:42:28","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=1557"},"modified":"2014-04-22T08:42:28","modified_gmt":"2014-04-22T07:42:28","slug":"memoria-tablak-meghajtasa-or-mapperrel","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2014\/04\/22\/memoria-tablak-meghajtasa-or-mapperrel\/","title":{"rendered":"Mem\u00f3ria t\u00e1bl\u00e1k meghajt\u00e1sa OR mapperrel"},"content":{"rendered":"<p>Az SQL Server 2014-es mem\u00f3riat\u00e1bl\u00e1kat csak akkor lehet a lehet\u0151 legk\u00f6zvetlenebb m\u00f3don el\u00e9rni, ha nat\u00edv k\u00f3dra ford\u00edtott t\u00e1rolt elj\u00e1r\u00e1sokkal \u00e9rj\u00fck el. Az OR mapperek viszont alapban sima, dinamikus SQL-eket gener\u00e1lnak. Ha \u00edgy akarunk CRUD m\u0171veleteket v\u00e9grehajtani egy mem\u00f3ria t\u00e1bl\u00e1n, akkor az \u00e1tmegy a szerver interop r\u00e9teg\u00e9n, ami jelent\u0151sen belass\u00edtja azt. T\u00f6bbsz\u00f6r\u00f6s\u00e9re. Emiatt -jelen tud\u00e1som szerin-, ha OR mapperel akarjuk meghajtani a mem\u00f3ria t\u00e1bl\u00e1kat, akkor saj\u00e1t spket kell \u00edrni. Kipr\u00f3b\u00e1ltam a dolgot, de falakba \u00fctk\u00f6ztem. Ugyanis az OR mapperek elv\u00e1rj\u00e1k, hogy pl. egy update ut\u00e1n visszaadja a szerver az xxx rows affected information message-et, ebb\u0151l tudja az OR mapper, hogy siker\u00fclt a sor m\u00f3dos\u00edt\u00e1sa. Ha nem j\u00f6n vissza semmi, akkor azt hiszi, hogy az optimista konkurencia ellen\u0151rz\u00e9s miatt nem siker\u00fclt a sor m\u00f3dos\u00edt\u00e1sa (azt hiszi valaki k\u00f6zben m\u00f3dos\u00edtotta vagy t\u00f6r\u00f6lte a sort), \u00edgy exceptiont dob. Viszont a mem\u00f3ria t\u00e1bl\u00e1s update NEM adott vissza XXX rows affected \u00fczenetet, \u00edgy az OR mapper exceptiont dob (NHibernate.StaleObjectStateException \u00e9s ).<br \/>\nA megold\u00e1s teh\u00e1t val\u00f3sz\u00edn\u0171leg az lehet, hogy ki kell kapcsolni az OR mapper optimista konkurrencia ellen\u0151rz\u0151j\u00e9t.<br \/>\nEgyel\u0151re NHibernate-n\u00e9l nem tal\u00e1ltam megold\u00e1st r\u00e1, legal\u00e1bbis a Conf ORM-es &#8220;code first&#8221; mapping m\u00f3dszerrel. EF-en m\u00e9g nem pr\u00f3b\u00e1ltam.<br \/>\nMindenesetre <a href=\"http:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/ecb8bf7b-164c-4762-a641-a642896b16f4\/rowcount-for-sql-server-2014-memory-tables?forum=sqldataaccess\">ki\u00edrtam<\/a> ms\u00e9khez a k\u00e9rd\u00e9st, ha j\u00f6n v\u00e1lasz, meg\u00edrom.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az SQL Server 2014-es mem\u00f3riat\u00e1bl\u00e1kat csak akkor lehet a lehet\u0151 legk\u00f6zvetlenebb m\u00f3don el\u00e9rni, ha nat\u00edv k\u00f3dra ford\u00edtott t\u00e1rolt elj\u00e1r\u00e1sokkal \u00e9rj\u00fck el. Az&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,25,6,74,88,4,30,87],"tags":[],"class_list":["post-1557","post","type-post","status-publish","format-standard","hentry","category-net","category-adonet","category-adatbazisok","category-entity-framework","category-nhibernate-adonet","category-szakmai-elet","category-sql-server","category-sql-server-2014"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1557"}],"version-history":[{"count":1,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1557\/revisions"}],"predecessor-version":[{"id":1558,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1557\/revisions\/1558"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}