.net - Overriding entity caching/change-tracking behaviour in Linq to SQL -


I think the original question might have been rotated very long with too much unnecessary details, so it My effort is simple to do

I am looking for a medium to do any of the tasks given below. I need to do only one, not all. If anyone knows any of these, please answer. So, it is possible to do any of the following in SQL:

  • A via DataContext by ExecuteQuery Remove> or ExecuteMethodCall without tracking those entities?

  • ExecuteQuery or ExecuteMethodCall and guarantee that I always receive fresh copies of results obtained from the database, even if Only those institutions have already been recovered and they are already in the identity cache?

  • Do not direct Linq to SQL

Restrictions:

  • Refresh method is out of question; The number of institutions is large and it will become a performance disaster.

  • I just do not have object tracking enabled to false , because datacontax After executing it does not allow setting it back to true , and I need some of institutions

  • I can not even remove the original DataContext and can not use a new one; I should be able to do this in the middle of the transaction.

This is starting to cause a serious problem, and I really feel that the default behavior is malicious if I execute an ad-hoc query or stored procedure So, I hope that the results I get are the exact result, which was given by the query that was said. It only makes sense; If I want old, stale entities, why would I go to the database to bring them back?

At the moment, my work is either (a) a new DataContext specifically for query and override transaction segregation level, or (B) return type "DTO" Which is similar to the unit in every way, but without [table] attribute, and map it is in the original unit using Automaker

I have been able to come up with a viable long term solution for this issue. This is not ideal at all, but it has been relatively painless for working so far and is less scary than the option.

Because these questions are pure SQL - they all ExecuteQuery for inline SQL or ExecuteMethodCall for stored procedures - I have decided that when I do not want to know the DataContext for example "raw" ado About some institutions

Of course, the examples of IDCCommand and manual mapping will pass through IDataReader , so I spent a few hours writing a code, heavy for me To carry a load, coding a library, "code" idb comma , an automatic "fluent" for LinqDataReaderMapper, which uses MetaModel Therefore, I want to overload the existing institutions without making amendments and to speed up writing simple questions. Extensions can I use a bunch of methods.

At the end of the day, I am writing something like this: 

  var result = context. Connection Commands ("Select Column 1, Table 2" from column 2, where "Filter Filter 1 = @ Ultimate 1 and FilterCol2 = @ Ultimate 2"). Parameter (P = & gt; P. Name ("Para 1"). Value (some value), P = & gt; P. Name ("Para 2"). Value (some other value)). Exact Reader () Map (context mapping). & Lt; MyEntity & gt; ();

Or just this: 

  var result = context .ExecuteQueryRaw & lt; MyEntity & gt; (CommandType.StoredProcedure, "SomeProc", new {Param1 = someValue, Param2 = some other values});

I am not posting the entire code for it - it is too long and I think it will be just a big tl, dr at this point - But the main idea is that they both have a IEnumerable & lt; MyEntity & gt; return, and because they are being copied directly from the IDataReader , they are essentially separate entities - Datacontax about any direct There is no knowledge and therefore neither can block the results nor track them after the fact.

Therefore, the problem was resolved partially, though it would be even better if I just get DataContext to behave yourself.


Comments

Post a Comment

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

I am using my first project LINQ (in mvc), so maybe there's something very simple that I remember. However, a day of searching and experimenting does not work, so it works. I am trying to write a LINQ query (Linux to SQL) in which in many cases where the statement is different from an OR or an AND. We do not know how many conditions are going in the query till runtime. This search is for filter control, where the user can choose multiple criteria for filtering. Select from table where table.col = 1 or table.col = 2 or table.col = 7 .... 'Other number of conditions Before I just create the SQL query as a string, while looping over all the situations. However, it seems that there should be a good way to do this in LINQ. I tried to use Expression trees, but they had a second thought for this moment on my head, where the lambda function was to be executed inside the statement such as: values ​​for matchingRows = matchingRows for each value Where (function (row) row.c...
Read more

asp.net mvc - Dynamically Generated Ajax.BeginForm -

I have a problem with ASP.NET MVC Ajax forms. I generate many Ajax form in a table such as: & Lt; Input type = "submit" name = "activity" value = "add activity" / & gt; & Lt;%}% & gt; & Lt; / TD & gt; & Lt; / TR & gt; & Lt;%}% & gt; So far so good. When I post one of those forms, it gives a partial view in a div, and in this new partial view a new Ajax Beginnform (which is not in Genesis form) This second Ajax Beginnorf is exactly like the ones I got on the table, but when I post it, I do not get the "Ajax Post", but a normal post that sends me to a new page, I do not know whether the two Ajax forms What is the reason for the difference between, why is it the "dynamically generated" Ajax form behaves like a normal HTML form? By the way, I know that I can do it in different ways using javascript, but I would like to understand whether it can only be done using MVC helplars and Ajax lib...
Read more

Debug on symbian -

I am using trk for phone debug This works well for the Holorld project But when I start the project in phone debug mode 1) the load failed 2) TrkProtocolPlugin: to target the specified file Failure (please verify If any body understands what problem I am experiencing, then this problem helps me Pre-release If the application has the privileges assigned (with the appropriate certificate) itemprop = "text" > In your case, I will check: / li> If there is no conflict of application ID with any other application of device If there are problematic commands in the installation package (for example copy copy for non-accessible directories)
Read more