Hello,
I would like to use System.TransactionScope from Visual Studio 2005
(with DDEX provider).
I created dataset (table adapter) with all insert, update, select,
etc... funcitons.
Later I added on asp.net web form DetailsView1 control and it
created ObjectDataSource1, which takes data from
"DataSet1TableAdapters". And problem is that I fill DetailsView control
for data insertion, and press some button, so that later from code I
could insert data, BUT in transactionscope, it inserts data and after
exception, data is still in database, so no transactions here. For
runtime I use FireBird .net provider 2.1.0.0 Beta 2. Where could be the
problem?
Could some one post here sample of using TransactionScope with
Firebird database, as I heard support for TransactionScope should be
implemented in FireBird .net provider 2.1.0.0 Beta 2.
Code fragments:
using (TransactionScope ts = new TransactionScope())
{
DetailsView1.InsertItem(false);
throw new Exception("Test");
ts.Complete();
}
...
Fragment from aspx file of ObjectDataSource:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DeleteMethod="Delete"
InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="ClassLibrary1.DataSet1TableAdapters.USERSTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
Thanks a lot in advance,
Madars Vitolins
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
