Json Serializing EF object without relationships

Question

I am trying to store a Json serialized EF object in another database.

One of the items I'm strying to store is the cart, which has some relateded tables.

How can I store the cart, without dragging its relations along (preferably without resorting to .Select() to handpick the distinct columns)

[AllowAnonymous]
public ActionResult Test() {

    using (var db = new DALEntities())
    {
        var q = db.tblCarts.SingleOrDefault(x => x.CartItemID == 4275);

        q.tblContactsExtra = null;
        q.TBLINVENTORY = null;

        var settings = new JsonSerializerSettings {PreserveReferencesHandling = PreserveReferencesHandling .Objects} ;

        var str = JsonConvert.SerializeObject(q, settings);

        return Content(str);
    }

So you want to break your own referential integrity? Just set the foreign keys to allow nulls. — Mathew Thompson
– Mathew Thompson, Commented Apr 24, 2013 at 14:19
I only want to store, for this small purpose, the single table...if I add in all the referential data, the amount stored increases by several orders of magnitude. I don't need to reference that data in this case, so I also wish not to store it. — reidLinden
– reidLinden, Commented Apr 24, 2013 at 14:23
and then the code above will operate? or will I have to do something else too? — reidLinden
– reidLinden, Commented Apr 24, 2013 at 14:25

Mathew Thompson · Accepted Answer · 2013-04-24 14:32:22Z

2

Unfortunately, you'll have to set your foreign keys to allow nulls. Otherwise you won't be able to achieve what you're looking to achieve. To do that, just make the ID fields nullable, something like:

public int? ContactsExtraId { get; set; }
public virtual tblContactsExtra tblContactsExtra { get; set; }

public int? InventoryId { get; set; }
public virtual TblInventory TBLINVENTORY { get; set; }

answered Apr 24, 2013 at 14:32

Mathew Thompson

56.5k15 gold badges130 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Json Serializing EF object without relationships

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related