sql server - Linq-To-SQL Legacy Relation Mapping -

-

I am trying to get Linq2SQL to work with my legacy database. I currently have a note table which is normal for some different entities and has been mapped: I, who design this database, instead of mapping a connection table of each unit type, they have a type of column (A varchar yuck!) As a single relationship table.

How do I map the notes in Foo and Bar? Is it also possible I am not seeing light? I tried two sections FooNotes and BarNotes which passed the RelateNotes and then mapped the type field as pigment.

It does not work and I get the following error. 

  Poor storage property: '_EntityID' member 'at TestLinq.BarNotes. EntityID '.

Before realizing this possible, I do not want to go very far from the Linq2SQL road. I do not have permission to change the database too much.

Many thanks,

I included a domain model based layered architecture Will consider expanding the design of your app.

In this way, you can create a domain model that meets the requirements of the system while mapping works down. For example, you may have a general interface for data access layer which gives mapped organizations. An implementation of this interface can be made for the old 'string-equality' M2M relationship in the heritage database. One day when you are ready to dig legacy databases, a new implementation can be made for a separate AR-DB model, which will allow your domain model (object model) and high layers (services, UI etc) to remain unchanged. (Because they use all common interfaces.).

In your object model, you can define each object that requires notes and each of them has notes collection for each instance. for example. Fu has a collection of notes; There is a collection of notes in the bar, your repository interface will look after these entities return, but there will be concern about the implementation of the repo how it reads and remains in DB.


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st...
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a...
Read more

php - jQuery AJAX Post not working -

-
I do not understand why this script does not work. It has something to do within AJAX PostScript / Function. Right now, when I submit my form, it runs php code on the same page. What it should do, send the values ​​of the form for Project_Azax.fp, then there will be a refund of success on the page which is correct or false. $ (document) .ready (function () {$ ('div # didIt'). Hide (); $ ('form [name = adminForm]'). Submit (function () ($ {'.post' ('/ project_ajax.php', {action: $ ('[name = action]') Val (), pId: $ ('[name = pId]'). Val (), name ('[Name = name]'. Val (), url: $ ('[url = url]'). Val (), summary: ('[summary = summary]'). Val ()}, Function (data) {if (data.success) {$ ('div # didIt') .Sliddown ('slow');} and {warning ('unsuccessful SA!');}}, 'Jason'); return false ;});}); What is the code for project_ajax.php below ... if ($ _ POST ['action'] == ...
Read more