コード例 #1
0
        public object SetObjectData(object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
        {
            SqlParameter par = (SqlParameter)obj;

            par.ParameterName = info.GetString("ParameterName");
            par.DbType        = SurrogateEnumSetter.Parse <DbType>(info, "DbType");
            par.Direction     = SurrogateEnumSetter.Parse <ParameterDirection>(info, "Direction");
            par.Value         = info.GetValue("Value", typeof(object));
            par.Size          = info.GetInt32("Size");
            par.IsNullable    = info.GetBoolean("IsNullable");
            return(null);
        }
コード例 #2
0
        public object SetObjectData(object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
        {
            SqlCommand comm = (SqlCommand)obj;

            comm.CommandText = info.GetString("CommandText");
            comm.CommandType = SurrogateEnumSetter.Parse <CommandType>(info, "CommandType");
            int parcount = info.GetInt32("ParametersCount");

            for (int i = 0; i < parcount; i++)
            {
                SqlParameter par = (SqlParameter)info.GetValue("Parameter" + i, typeof(SqlParameter));
                comm.Parameters.Add(par);
            }
            return(null);
        }
コード例 #3
0
        public static SqlCommand FromByteArray(byte[] array)
        {
            /*
             * var ss = new SurrogateSelector();
             * ss.AddSurrogate(typeof(SqlCommand), new StreamingContext(StreamingContextStates.All), new SqlCommandSurrogate());
             * ss.AddSurrogate(typeof(SqlParameter), new StreamingContext(StreamingContextStates.All), new SqlParameterSurrogate());
             * return Serializer.FromByteArray<SqlCommand>(array, ss);
             */
            SqlCommand cmd = new SqlCommand();

            using (MemoryStream stm = new MemoryStream(array))
            {
                using (BinaryReader reader = new BinaryReader(stm))
                {
                    cmd.CommandText = reader.ReadString();
                    cmd.CommandType = SurrogateEnumSetter.Parse <CommandType>(reader.ReadString());
                    int parcnt = reader.ReadInt32();
                    for (int i = 0; i < parcnt; i++)
                    {
                        string       name = reader.ReadString();
                        SqlParameter par  = cmd.Parameters.AddWithValue(name, null);
                        par.DbType    = SurrogateEnumSetter.Parse <DbType>(reader.ReadString());
                        par.Direction = SurrogateEnumSetter.Parse <ParameterDirection>(reader.ReadString());
                        string type = reader.ReadString();
                        switch (type)
                        {
                        case "DBNull":
                            reader.ReadString();
                            par.Value = DBNull.Value;
                            break;

                        case "Boolean":
                            par.Value = reader.ReadBoolean();
                            break;

                        case "Double":
                            par.Value = reader.ReadDouble();
                            break;

                        case "Decimal":
                            par.Value = reader.ReadDecimal();
                            break;

                        case "Int16":
                            par.Value = reader.ReadInt16();
                            break;

                        case "Int32":
                            par.Value = reader.ReadInt32();
                            break;

                        case "Int64":
                            par.Value = reader.ReadInt64();
                            break;

                        case "String":
                            par.Value = reader.ReadString();
                            break;

                        case "DateTime":
                            par.Value = DateTime.ParseExact(reader.ReadString(), "yyyy-MM-dd HH:mm:ss.fffffff", null);
                            break;

                        case "Byte[]":
                            par.Value = reader.ReadBytes(reader.ReadInt32());
                            break;

                        case "(null)":
                            reader.ReadString();
                            par.Value = null;
                            break;

                        default:
                            reader.ReadString();
                            par.Value = null;
                            break;
                        }
                        par.Size       = reader.ReadInt32();
                        par.IsNullable = reader.ReadBoolean();
                    }
                }
            }
            return(cmd);
        }