Esempio n. 1
0
        static void InsertRecord(ToCheck1 obj)
        {
            NpgsqlConnection con = new NpgsqlConnection("Server = 127.0.0.1; User Id = postgres; Password=postgres;Database=sportsweb;");

            con.Open();

            string TempInsertUninitializedItemSql = string.Format(
                "INSERT INTO {0}(SessionId, SessionItemLong, Timeout, Expires, Locked, LockDate, LockDateLocal, LockCookie, Flags)VALUES" +
                "(:{1}, :{2}, :{3}, :{4},0 :: bit, :{5}, :{6},1,1)",
                "ASPStateTempSessions",
                (object)SqlParameterName.SessionId,
                (object)SqlParameterName.SessionItemLong,
                (object)SqlParameterName.Timeout,
                (object)SqlParameterName.Expires,
                (object)SqlParameterName.LockDate,
                (object)SqlParameterName.LockDateLocal);

            var stream = SerializeObject(obj);
            var buff   = stream.ToArray();


            NpgsqlCommand cmd = new NpgsqlCommand(TempInsertUninitializedItemSql);

            cmd.Connection = con;
            cmd.Parameters.AddSessionIdParameter(SessionId1)
            .AddSessionItemLongParameter(Convert.ToInt32(stream.Length), buff)
            .AddTimeoutParameter(20)
            .AddLockDateParameter().AddLockDateLocalParameter();

            cmd.ExecuteNonQuery();
        }
Esempio n. 2
0
        public static MemoryStream SerializeObject(ToCheck1 item)
        {
            MemoryStream stream    = new MemoryStream();
            IFormatter   formatter = new BinaryFormatter();

            formatter.Serialize(stream, item);
            return(stream);
        }
Esempio n. 3
0
        static void Main(string[] args)
        {
            //NpgsqlConnection con = new NpgsqlConnection("Server = 127.0.0.1; User Id = postgres; Password=postgres;Database=sportswebtest;");
            //con.Open();
            //NpgsqlCommand cmd = new NpgsqlCommand("select * from aspstatetempsessions");
            //cmd.Connection = con;

            string id = "9888333";

            var itemtoInsert = new ToCheck1()
            {
                IntValue = 3, S1 = "My Check Value", booleanvalue = true, decValue = 3.90m, doubleValue = 8.409
            };

            //   InsertRecord(itemtoInsert);
            // UpdateAndRead();
            //ReadRecord();
            GetStateItemExclusiveSql_Query();
        }