コード例 #1
0
 public static int EFInsertUpdate <T>(this MySqlConnection connection, T instance, string table)
 {
     using (var cmd = EntityCommandBuilder.BuildInsertUpdateCommand(instance, table, connection))
     {
         return(cmd.ExecuteNonQuery());
     }
 }
コード例 #2
0
 public static async Task <int> EFInsertUpdateAsync <T>(this MySqlConnection connection, T instance, string table)
 {
     using (var cmd = EntityCommandBuilder.BuildInsertUpdateCommand(instance, table, connection))
     {
         return(await cmd.ExecuteNonQueryAsync());
     }
 }
コード例 #3
0
        /// <summary>
        /// Creates the object in the database table.
        /// If an item with the same primary or unique key exists, it will update it instead.
        /// </summary>
        /// <param name="Obj">The object to create</param>
        /// <param name="Table">The table to create the object in</param>
        public async Task InsertUpdateAsync <T>(T Obj, string Table)
        {
            using (MySqlConnection connection = GetConnection(autoOpen: false, forceNew: true))
            {
                await connection.OpenAsync();

                using (MySqlCommand Command = EntityCommandBuilder.BuildInsertUpdateCommand <T>(Obj, Table, connection))
                {
                    await Command.ExecuteNonQueryAsync();
                }
                await connection.CloseAsync();
            }
        }
コード例 #4
0
 /// <summary>
 /// Creates the object in the database table.
 /// If an item with the same primary or unique key exists, it will update it instead.
 /// </summary>
 /// <param name="Obj">The object to create</param>
 /// <param name="Table">The table to create the object in</param>
 public void InsertUpdate <T>(T Obj, string Table)
 {
     if (ReuseSingleConnection)
     {
         lock (ActiveConnection)
         {
             using (MySqlCommand Command = EntityCommandBuilder.BuildInsertUpdateCommand <T>(Obj, Table, ActiveConnection))
             {
                 Command.ExecuteNonQuery();
             }
         }
     }
     else
     {
         using (MySqlConnection connection = new MySqlConnection(ConnectionString))
         {
             connection.Open();
             using (MySqlCommand Command = EntityCommandBuilder.BuildInsertUpdateCommand <T>(Obj, Table, connection))
             {
                 Command.ExecuteNonQuery();
             }
         }
     }
 }