Override Table Insert

[Lucas Phillip]

Greetings,

We are porting our SQL Server / Linq2Sql program to Infobright (database) / LinqConnect.

Since Infobright uses mysql frontend, I can use LinqConnect with it.
I got 6 tables using MyISAM that work with no problem. But I got one that uses Infobright engine and it does not suport DML (insert, update, delete) queries.

Is there a way I can override or customize the insert behavior of LinqConnect? I need to prevent that one table to be inserted in the regular way modify to the one that works.

Thanks

[StanislavK]

Could you please describe the behaviour you need to implement for the update operations?

For example, if you need to use some stored procedures, you can perform the following:
- add these procedures to the model (e.g., drag and drop them from Database Explorer to the model canvas);
- select the 'Configure Behaviour...' item from the context menu of the corresponding entity class;
- select the desired procedure for each operation.

If you need to perform some other actions when running the update commands, you can implement the partial methods as described in the following topic:
http://www.devart.com/linqconnect/docs/ ... thods.html

Please tell us if this helps.

[Lucas Phillip]

Well, the DB does not support INSERT queries, only LOAD DATA. So, we wanted to override InsertOnSubmit to save the data we wanted on a file and SubmitChanges to execute a LOAD DATA INFILE command with that file.

I think we will extend the behavior of those classes and add new methods, or use your sugestion.

Thanks