Hello
How do you get hash bytes from XML?
checksum() and hashBytes() don't work with XML AS IS. I am handling legal
document. I don't want additional convert like nvarchar or something. I
just want to get the hashbytes from pure XML or stream as is.
Currently I am using CLR, but I think there can be shorter way to do that.
Not only hash but also checksum will do because the computing occurs in safe
place, the DB.
public static byte[] toHash(SqlXml sqx)
{
XmlDocument doc=new XmlDocument();
doc.Load(sqx.CreateReader());
MemoryStream ms = new MemoryStream();
doc.Save(ms);
ms.Position = 0;
BinaryReader br = new BinaryReader(ms);
byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
SHA1Managed sha = new SHA1Managed();
byte[] hash = sha.ComputeHash(bs);
return (hash);
}
This morning I got smarter and shortened the code into 3 lines.
> public static byte[] toHash(SqlBytes sbs)
> {
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(sbs);
> return (hash);
> }
Callere is dbo.toHash(convert(varbinary(max), @.xml))
I am even considering remove the CLR. Then the code may be,
hashBytes('sha1', convert(varbinary(max), @.xml))
But I discovered dotnet sha1 and SQL Server sha1 return different result.
Even the lengths of the results are different. I prefered dotnet, but I am
studying still, and any recommandation will be appreciated.
"Han" <hp4444@.kornet.net.korea> wrote in message
news:%23vHtSwwkHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hello
> How do you get hash bytes from XML?
> checksum() and hashBytes() don't work with XML AS IS. I am handling legal
> document. I don't want additional convert like nvarchar or something. I
> just want to get the hashbytes from pure XML or stream as is.
> Currently I am using CLR, but I think there can be shorter way to do that.
> Not only hash but also checksum will do because the computing occurs in
> safe place, the DB.
> public static byte[] toHash(SqlXml sqx)
> {
> XmlDocument doc=new XmlDocument();
> doc.Load(sqx.CreateReader());
> MemoryStream ms = new MemoryStream();
> doc.Save(ms);
> ms.Position = 0;
> BinaryReader br = new BinaryReader(ms);
> byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(bs);
> return (hash);
> }
>
Showing posts with label hash. Show all posts
Showing posts with label hash. Show all posts
Sunday, February 26, 2012
Getting hashbytes from XML
Getting hashbytes from XML
Hello
How do you get hash bytes from XML?
checksum() and hashBytes() don't work with XML AS IS. I am handling legal
document. I don't want additional convert like nvarchar or something. I
just want to get the hashbytes from pure XML or stream as is.
Currently I am using CLR, but I think there can be shorter way to do that.
Not only hash but also checksum will do because the computing occurs in safe
place, the DB.
public static byte[] toHash(SqlXml sqx)
{
XmlDocument doc=new XmlDocument();
doc.Load(sqx.CreateReader());
MemoryStream ms = new MemoryStream();
doc.Save(ms);
ms.Position = 0;
BinaryReader br = new BinaryReader(ms);
byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
SHA1Managed sha = new SHA1Managed();
byte[] hash = sha.ComputeHash(bs);
return (hash);
}This morning I got smarter and shortened the code into 3 lines.
> public static byte[] toHash(SqlBytes sbs)
> {
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(sbs);
> return (hash);
> }
Callere is dbo.toHash(convert(varbinary(max), @.xml))
I am even considering remove the CLR. Then the code may be,
hashBytes('sha1', convert(varbinary(max), @.xml))
But I discovered dotnet sha1 and SQL Server sha1 return different result.
Even the lengths of the results are different. I prefered dotnet, but I am
studying still, and any recommandation will be appreciated.
"Han" <hp4444@.kornet.net.korea> wrote in message
news:%23vHtSwwkHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hello
> How do you get hash bytes from XML?
> checksum() and hashBytes() don't work with XML AS IS. I am handling legal
> document. I don't want additional convert like nvarchar or something. I
> just want to get the hashbytes from pure XML or stream as is.
> Currently I am using CLR, but I think there can be shorter way to do that.
> Not only hash but also checksum will do because the computing occurs in
> safe place, the DB.
> public static byte[] toHash(SqlXml sqx)
> {
> XmlDocument doc=new XmlDocument();
> doc.Load(sqx.CreateReader());
> MemoryStream ms = new MemoryStream();
> doc.Save(ms);
> ms.Position = 0;
> BinaryReader br = new BinaryReader(ms);
> byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(bs);
> return (hash);
> }
>
How do you get hash bytes from XML?
checksum() and hashBytes() don't work with XML AS IS. I am handling legal
document. I don't want additional convert like nvarchar or something. I
just want to get the hashbytes from pure XML or stream as is.
Currently I am using CLR, but I think there can be shorter way to do that.
Not only hash but also checksum will do because the computing occurs in safe
place, the DB.
public static byte[] toHash(SqlXml sqx)
{
XmlDocument doc=new XmlDocument();
doc.Load(sqx.CreateReader());
MemoryStream ms = new MemoryStream();
doc.Save(ms);
ms.Position = 0;
BinaryReader br = new BinaryReader(ms);
byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
SHA1Managed sha = new SHA1Managed();
byte[] hash = sha.ComputeHash(bs);
return (hash);
}This morning I got smarter and shortened the code into 3 lines.
> public static byte[] toHash(SqlBytes sbs)
> {
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(sbs);
> return (hash);
> }
Callere is dbo.toHash(convert(varbinary(max), @.xml))
I am even considering remove the CLR. Then the code may be,
hashBytes('sha1', convert(varbinary(max), @.xml))
But I discovered dotnet sha1 and SQL Server sha1 return different result.
Even the lengths of the results are different. I prefered dotnet, but I am
studying still, and any recommandation will be appreciated.
"Han" <hp4444@.kornet.net.korea> wrote in message
news:%23vHtSwwkHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hello
> How do you get hash bytes from XML?
> checksum() and hashBytes() don't work with XML AS IS. I am handling legal
> document. I don't want additional convert like nvarchar or something. I
> just want to get the hashbytes from pure XML or stream as is.
> Currently I am using CLR, but I think there can be shorter way to do that.
> Not only hash but also checksum will do because the computing occurs in
> safe place, the DB.
> public static byte[] toHash(SqlXml sqx)
> {
> XmlDocument doc=new XmlDocument();
> doc.Load(sqx.CreateReader());
> MemoryStream ms = new MemoryStream();
> doc.Save(ms);
> ms.Position = 0;
> BinaryReader br = new BinaryReader(ms);
> byte[] bs = br.ReadBytes(Int32.Parse(ms.Length.ToString()));
> SHA1Managed sha = new SHA1Managed();
> byte[] hash = sha.ComputeHash(bs);
> return (hash);
> }
>
Subscribe to:
Posts (Atom)