使用Oracle資料表保存GUID屬性

            Guid g = Guid.NewGuid();

            Console.WriteLine("Orig Guid : {0}", g);

            byte[] b = g.ToByteArray();

            Console.WriteLine("ToByteArray : {0}", BitConverter.ToString(b));

            Guid r = new Guid(b);

            Console.WriteLine("new Guid(byte[]) : {0}", r);

            string s = g.ToString("N");

            r = new Guid(s);

            Console.WriteLine("new Guid(\"{0}\") : {1}", s, r);

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Afet.Attachment

{

    public static class GuidConverter

    {

        //REF: http://stackoverflow.com/a/17168469/4335757

        /// <summary>

        /// A CLSCompliant method to convert a big-endian Guid to little-endian

        /// and vice versa.

        /// The Guid Constructor (UInt32, UInt16, UInt16, Byte, Byte, Byte, Byte,

        ///  Byte, Byte, Byte, Byte) is not CLSCompliant.

        /// </summary>

        public static Guid FlipEndian(this Guid guid)

        {

            var newBytes = new byte[16];

            var oldBytes = guid.ToByteArray();

            for (var i = 8; i < 16; i++)

                newBytes[i] = oldBytes[i];

            newBytes[3] = oldBytes[0];

            newBytes[2] = oldBytes[1];

            newBytes[1] = oldBytes[2];

            newBytes[0] = oldBytes[3];

            newBytes[5] = oldBytes[4];

            newBytes[4] = oldBytes[5];

            newBytes[6] = oldBytes[7];

            newBytes[7] = oldBytes[6];

            return new Guid(newBytes);

        }

        public static byte[] ToRaw16(this Guid guid)

        {

            return guid.FlipEndian().ToByteArray();

        }

        public static Guid FromRaw16(byte[] raw)

        {

            return new Guid(raw).FlipEndian();

        }

    }

} 

    /// <summary> 

    /// 附件容器 

    /// </summary> 

    public class AttachmentContainer 

    { 

        /// <summary> 

        /// 附件所屬項目識別碼 

        /// </summary> 

        public Guid OwnerId { get; set; }

        /// <summary> 

        /// 附件所屬項目識別碼（Byte[]版本） 

        /// </summary> 

        [JsonIgnore] 

        public byte[] OwnerIdRaw { 

            get 

            { 

                return OwnerId.ToRaw16(); 

            } 

             set 

            { 

                OwnerId = GuidConverter.FromRaw16(value); 

            } 

        }