Store assembly files to Sql server 2005

Question

Hi I have some assembly files which need to be copied from production to datalist.Then assembly files needs to be stored in sql CLR. Could anyone help on this. Thanks Prasant

Josip Juric · Answer

For this problem is this procedure: First you need load your asembly files by using System.IO.BinaryReader class in memory: FileStream fs=new FileStream(@myAssembly file name FileMode.Open FileAccess.Read); BinaryReader br=new BinaryReader(fs); byte[] assembly; assembly = br.ReadBytes((int)fs.Length); Then you insert data in sqlDataBase using ordinary sqlCommand(if you don't know sqlCommand's yust say).