Ejemplo n.º 1
0
        /// <summary>
        /// Testable AllMainRows
        /// </summary>
        /// <typeparam name="M"></typeparam>
        /// <param name="db">The database.</param>
        /// <param name="filter">encrypt filter</param>
        /// <returns></returns>
        public static IEnumerable <Main> AllMainRows <M>(ASP_DBEntities db, Func <byte[], byte[]> filter = null)
            where M : class
        {
            var all = from m in db.Main
                      select m;

            return(from m in all.AsEnumerable()
                   where m.clsid == Clsid.Id(typeof(M)) &&
                   m.GetInstance <M>(filter) != null        // could be encrypted
                   select m);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Testable SaveMain
        /// </summary>
        /// <typeparam name="M"></typeparam>
        /// <param name="db">The database.</param>
        /// <param name="instance">The instance.</param>
        /// <param name="session">The session.</param>
        /// <param name="filter">encrypt filter</param>
        /// <returns></returns>
        public static Guid SaveMain <M>(ASP_DBEntities db, M instance, Guid?session, Func <byte[], byte[]> filter = null)
            where M : class
        {
            var query = from m in db.Main
                        where m.session == session
                        select m;
            var main = query.FirstOrDefault();

            if (main == null)
            {
                main       = new Main();
                main.clsid = Clsid.Id(instance);
                db.Main.Add(main);      // INSERT
            }
            main.SetInstance(instance, filter);
            db.SaveChanges();
            return(main.session);  // get the new session guid set by the db on insert
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Returns the (unencrypted!) literal INSERT string of the loaded object
        /// for manually exporting session dumps.
        /// </summary>
        /// <returns>
        /// SQL INSERT string
        /// </returns>
        public string InsertSQL()
        {
            Trace.Assert(this.main != null, "Explicit serialization with SetInstance(controlStorage.Main) required beforehand");
            var clsid = Clsid.Id(this.mainInstance);    // throws if no Clsid attribute present

            // Let the future consumer SQL Server encode the string representation of the byte[]
            string hex   = String.Empty;
            var    query = "SELECT CONVERT(VARCHAR(MAX), @main, 1) AS [hex]";

            using (var db = new ASP_DBEntities())
            {
                var param = new SqlParameter("main", this.main);
                hex = db.Database.SqlQuery <String>(query, param).FirstOrDefault();
            }
            // Format according to get copy-pasted into Management Studio
            return(String.Format("INSERT INTO Main (clsid, main) SELECT '{0}', {1}\n" +
                                 "SELECT session FROM Main WHERE mainid = @@IDENTITY\n",
                                 clsid, hex));
        }