Linq to sql multiple data context in same transaction -

-

I am working on a project where I have multiple reposetories to fetch data from differnt tables. I have all my treasures free They create new datacontacts, add rows to the table and apply the change commands. Now if in my service, there is a situation where I have to put data in several tables, but it should be in a transaction. I can get it using TrnasctionScope stuff, but they require data. As I am using StrucutreMap to create my objects, I can not get the same data reference, so my transaction fails.

Here are my objects. 

  Interface Iconation {MyDataContext GetContext (); } Public class connection: Iconation {public MyDataContext GetContext (new {{New MyDataContext back}); }} Interface IRepositryA {int SaveDataA (objectA A); } Public Class Repository A: IRAPOSITIA {Public Ink Service (Object AA) {var context = Object factory.Get instance & lt; Iconization & gt; (). GetContext (); Context.TableA.InsertOnSubmit (a); Context.SubmitChanges (); Back a.ID; }} Interface IRepositryB {int SaveDataA (objectB b); } Public Class Repository A: IRAPositry {Public Ink Service B (Object BB) {var context = Object factor. Get Instance & Lt; Iconation & gt; (). GetContext (); Context.TableB.InsertOnSubmit (b); Context.SubmitChanges (); Return b.ID; Now in my service layer, I have called them as the  
  Public MySivaClass () {Public SevenAll (Object AA, Obszeib B) {using (TransactionScope Tran); {ObjectFactory.GetInstance & lt; IRepositryA & gt; (). SaveDataA (A); B.FKID = AIID; ObjectFactory.GetInstance & LT; IRepositryB & gt; () SaveDataB (b). Trn.complete (); }}}  
 
 How would I pass the same data reference for two differnt repositories? I thought that I was creating an overloaded method in each repository, which was given below the IDataContext parameter Accepts 
   Interface IRAP positories {Int. ServiceData (Object AA); Int. Savata (Iconction Connection, Object AA); } Public Class Repository A: IRPository {Public Ink Service (Object AA) {var connection = ObjectFitcher. Gate instances and lt; Iconation & gt; (); Return Service Data (connection, A); } Public Inch Services (Iconction Connection, Object AA) {var context = connection.GetContext (); Context.TableA.InsertOnSubmit (a); Context.SubmitChanges (); Back a.ID; }} Interface IRepositryB {int SaveDataA (objectB b); Intetetetta (Iconction Connection, Object BB); } Public Class Repository A: IEPository {Public Ink Service B (Object BB) {var connection = Object Factory.Get instance & lt; Iconation & gt; (); Return service data (connection, b); } Public Inch Services (Iconction Connection, Object BB) {var reference = Connection. GateContact (); Context.TableB.InsertOnSubmit (b); Context.SubmitChanges (); Return b.ID; }}

And in my service level, I will implement it in the form of Public MySivaClass () {Public Service (Object A, ObserveBB) 

  {Iconction Connection = ObjectFactory.GetInstance & lt; IConnection & gt; (); (TransactionScope trn); {ObjectFactory.GetInstance & lt; IRepositryA & gt; (). SaveDataA (connection, A); B.FKID = AIID; ObjectFactory.GetInstance & LT; IRepositryB & gt; () SaveDataB (connection, b); Trn.complete (); The other thing is that if I call the GetContext method, then in some way I can configure DataContext to return the same connection. Therefore all the treasures will use the same connection. But I think the connection will survive all the time. I want to make this connection available only during the time of this SaveAll method. 
 
 Information about your help will be given. Thanks in advance. 
 
 Cheers Permindor

Transaction scope should be used with many datacontaxes However, as soon as there are more than one connection, the transaction is enhanced in an MSDTC / XA / distributed transaction. For that, you need to run MSDTC on both systems, where you run the code and on the database server.

Alternatively, if you make a clear relationship within the transaction, you can avoid the increase in a distributed transaction and pass it to your dataconsets; In this way, transaction scope will increase in a distributed transaction, and will not trust MSDTC ...


Comments

Post a Comment

Popular posts from this blog

MySql variables and php -

-
I am getting an error with php in order to format mysql_query () in php to format this string What is the right way? SELECT SELECT SELECT (*) Agents @AgentCount; User_Agent_English, User_Angent_Oursal, US.___Gent_Aginal, COUNT (User_Agent_Percade) ACC, COUNT (*) / (AgentCount) Percentage by agents user_agent_preser order DEC limit limit 50; In PHP, how am i setting $ query $ query = "SELECT count (*) agents @ agentcount; SELECT user_agent_parsed, User_agent_original , COUNT (user_agent_parsed) ascount, COUNT (*) / (@AgentCount) as a percentage by user_agent_parced by URI date DESC limit 50 "; This exact query will work properly if I put it in MySQL directly through a command line session. Do I need to release two separate php calls from mysql_query () and store the results first? I get the following error: There is an error in your SQL syntax; Instead of using a sub-selection and instead of using the 'SELECT user_agent_parsed, user_agent_original, ne
Read more

c# - How can I find out if there are windows above a control? -

-
If I have Winforms controls, can it be possible to tell whether the window above it (from any application)? Actually, I have to know that some parts of my control are actually appearing on the screen. If you are happy to p / call, the EnumWindows function provides all top-level windows HWND on the screen is; This allows you to get a Non-Client Rectangle (GetWindowRect) to compare the limits of your form. This non-rectangular opaque areas (media player and fancy skins for choice), so you can be false positive for such a control window.
Read more

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -

-
I have a strange problem that I really do not know. In addition to developing a new ASP.NET site, I have to support the old "classic ASP" site. It is written in VBScript with a batch of JavaScript functions. Many of the JavaScript functions include 'files' Everything is fine on our production system (which security is controlled by another group - this is a military installation) Debugging them once did not work I). However, I have a fix for a vague bug that needs to be fully tested and some functions do not run under the "local" copy of the website that runs on my PC. For the record, I am running IIS 5.1 on XP. The problem is that some Javascript functions are running "OK" on the production server, but when they use it as a server, they are not defined on my PC what is happening that last Programmer, for some reason, has decided to put some functions in a series of files, which according to the observations, imitate the "need_once
Read more