{"id":415,"date":"2012-04-13T21:51:38","date_gmt":"2012-04-13T21:51:38","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=415"},"modified":"2012-04-19T21:10:44","modified_gmt":"2012-04-19T21:10:44","slug":"guid-tipi-uniqueidentifier","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/guid-tipi-uniqueidentifier\/","title":{"rendered":"Guid Tipi (Uniqueidentifier)"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>SQL Server&#8217;da Uniqueidentifier ad\u0131 alt\u0131nda olan, 36 karakterden olu\u015fan bu tip, hi\u00e7bir \u015fekilde daha \u00f6nce olu\u015fturulan Uniqueidentifier tipinden verilerle, d\u00fcnyada kim nerede ne zaman olu\u015fturursa olu\u015ftursun, e\u015fle\u015fmeyen string bir ID \u00fcretmektedir.Genel yap\u0131s\u0131, bilgisayar\u0131n\u0131z\u0131n MAC adresi, saat, tarih vb. bir\u00e7ok \u00f6zelli\u011fi karman \u00e7orman ederek, 36 karakterlik bir string ID \u00fcretir.Asl\u0131nda 32 karakterden olu\u015fan bu tip, araya &#8220;-&#8221; karakterini ekleyip 35 karaktere \u00e7\u0131kmaktad\u0131r.Baz\u0131 sistemlerde ise 36 karakterden olu\u015fmaktad\u0131rlar.<br \/>\n<!--more--><br \/>\nSQL Server veritaban\u0131ndan kolonlar\u0131 \u00e7ekerken, nvarchar(50) tipindeki bir kolonun verilerini string property, field vb. gibi, int tipindeki bir kolonuda int property, field vb. gibi alanlarda tutabiliriz.Ancak Uniqueidentifier tipindeki kolonu, Guid referans tipinde tutabiliriz.Tabi Uniqueidentifier tipini string tipte bir elemanda tutabiliriz ama C#&#8217;ta Guid s\u0131n\u0131f\u0131 bu tipe g\u00f6re tasarlanm\u0131\u015ft\u0131r.<\/p>\n<p>Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar..<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>SQL Server&#8217;da Uniqueidentifier ad\u0131 alt\u0131nda olan, 36 karakterden olu\u015fan bu tip, hi\u00e7bir \u015fekilde daha \u00f6nce olu\u015fturulan Uniqueidentifier tipinden verilerle, d\u00fcnyada kim nerede ne zaman olu\u015fturursa olu\u015ftursun, e\u015fle\u015fmeyen string bir ID \u00fcretmektedir.Genel yap\u0131s\u0131, bilgisayar\u0131n\u0131z\u0131n MAC&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[200,119],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-asp-net","tag-guid","tag-uniqueidentifier"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=415"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/415\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}