> > is it possible to send an insert ignore statement to dblinq (based on > > a mysql database)? > > regards, > > I have no idea what an "insert ignore" statement is,
see http://dev.mysql.com/doc/refman/5.0/en/insert.html "•If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued. Data conversions that would trigger errors abort the statement if IGNORE is not specified. With IGNORE, invalid values are adjusted to the closest values and inserted; warnings are produced but the statement does not abort. You can determine with the mysql_info() C API function how many rows were actually inserted into the table. " > but (assuming it's > "standard" SQL) there's always DataContext.ExecuteCommand(): > > > http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.... great. thanks! regards, Matthijs > > This allows sending SQL directly to the DB with minimal DbLinq > machinations. > > - Jon -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
