public void Insert(Insert value, Action<long> yield) { WithConnection( c => { value.ExecuteNonQuery(c); yield(c.LastInsertRowId); } ); }
public Task<long> Insert(Insert value) { var id = -1L; WithConnection( c => { value.ExecuteNonQuery(c); id = c.LastInsertRowId; } ); return Task.FromResult(id); }
public long Insert(Insert value) { var id = -1L; WithConnection( c => { value.ExecuteNonQuery(c); id = c.LastInsertRowId; } ); return id; }
public Task <long> Insert(Insert value) { var id = -1L; WithConnection( c => { value.ExecuteNonQuery(c); id = c.LastInsertRowId; } ); return(Task.FromResult(id)); }
public long Insert(Insert value) { var id = -1L; WithConnection( c => { value.ExecuteNonQuery(c); id = c.LastInsertRowId; } ); return(id); }
public void Insert(Insert value, Action<long> yield) { Console.WriteLine("Insert enter"); WithWriteConnection( c => { Console.WriteLine("Insert before ExecuteNonQuery"); value.ExecuteNonQuery(c); yield(c.LastInsertRowId); Console.WriteLine("Insert after ExecuteNonQuery"); } ); Console.WriteLine("Insert exit"); }
public void Insert(Insert value, Action<long> yield) { //enter upload //enter upload //{ ContentType = image/jpeg, FileName = emspectrum.jpg, ContentLength = 82548, Length = 82548 } //{ ContentType = image/jpeg, FileName = emspectrum.jpg, ContentLength = 82548, Length = 82548 } //before insert { ManagedThreadId = 34 } //before insert { ManagedThreadId = 13 } //AsWithConnection... error: { ex = System.Data.SQLite.SQLiteBusyException (0x80004005) // at System.Data.SQLite.SQLiteCommand.ExecuteStatement(Vdbe pStmt, Int32& cols, IntPtr& pazValue, IntPtr& pazColName) // at System.Data.SQLite.SQLiteCommand.ExecuteStatement(Vdbe pStmt) // at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected) // at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() // at DropFileIntoSQLite.Schema.Table1Extensions.ExecuteNonQuery(Insert , IDbConnection ) WithConnection( c => { value.ExecuteNonQuery(c); yield(c.LastInsertRowId); } ); }
public void Insert(Insert content, Action<string> key) { Trace.w("Insert... " + new { content.AppSnapshotContent.Length }); // "C:\util\xampp-win32-1.8.0-VC9\xampp\mysql\bin\my.ini" //Caused by: java.lang.RuntimeException: Packet for query is too large (1199750 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. // at ScriptCoreLibJava.BCLImplementation.System.Data.SQLite.__SQLiteCommand.ExecuteNonQuery(__SQLiteCommand.java:275) // Caused by: java.sql.SQLException: Data truncation: Data too long for column 'AppSnapshotContent' at row 1 // http://stackoverflow.com/questions/8878779/sql-error-1406-data-too-long-for-column WithConnection( c => { content.ExecuteNonQuery(c); var LastInsertRowId = "" + c.LastInsertRowId; Trace.w("Insert " + new { LastInsertRowId }); key(LastInsertRowId); } ); }
public void Insert(Insert value, Action<long> yield) { //{ Message = "Attempt to write a read-only database\r\nattempt to write a readonly database", StackTrace = " at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)\r\n at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)\r\n at System.Data.SQLite.SQLiteDataReader.NextResult()\r\n at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)\r\n at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)\r\n at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()\r\n at SQLiteWithDataGridView.Schema.TheGridTableExtensions.ExecuteNonQuery(Insert , SQLiteConnection )\r\n at SQLiteWithDataGridView.Schema.TheGridTable.<>c__DisplayClass13.<Insert>b__12(SQLiteConnection c) in x:\\jsc.svn\\examples\\javascript\\forms\\SQLiteWithDataGridView\\SQLiteWithDataGridView\\Schema\\TheGridTable.cs:line 95\r\n at SQLiteWithDataGridView.Schema.XX.<>c__DisplayClass1.<AsWithConnection>b__0(Action`1 y) in x:\\jsc.svn\\examples\\javascript\\forms\\SQLiteWithDataGridView\\SQLiteWithDataGridView\\Schema\\TheGridTable.cs:line 161" } //WithConnection( WithWriteConnection( c => { value.ExecuteNonQuery(c); yield(c.LastInsertRowId); } ); }
public void Insert(Insert value) { #if DEBUG //Console.WriteLine("before Insert"); #endif WithWriteConnection( c => { if (ListMode) { InsertList.Add(value); // garbage collect // lesser values will cause glitches in slower clients // IE for example is not streaming, this will need a longer buffer for reconnects var memento = 64; if (InsertList.Count > memento) InsertList[InsertList.Count - memento] = null; //Console.Title = ("@ " + InsertList.Count); return; }; value.ExecuteNonQuery(c); } ); #if DEBUG //Console.WriteLine("after Insert"); #endif }