EF(entity framework) "using" statement and "try catch" withing each other

Question

Is there any difference between these ways of using/try-catch blocks?

First :

public bool Insert(SomeEntity entity)
{
    bool result = false;
    
    try
    {
        using (var db = new MyEntities())
        {
            db.AddToSomeEntity(entity);
            db.SaveChanges();
            
            result = true;
        }
    }
    catch (Exception e)
    {
        //
    }
    return result;
}

Second :

public bool Insert(SomeEntity entity)
{
    bool result = false;
    using (var db = new MyEntities())
    {
        try
        {
            db.AddToSomeEntity (entity);
            db.SaveChanges();
            result = true;
        }
        catch (Exception e)
        {
                    //
        }
    }
    
    return result;
}

Does it affect performance?

This string was added in order to satisfy SO submit validation rule.

COLD TOLD · Accepted Answer · 2013-08-04 05:33:28Z

1

I do not think it violates any rules it the idea at what point you want to send your context to garbage collection i would recommend using the second method since it more concrete and you will send the object to garbage collection when your function was totally executed otherwise you might be getting an exception where you try to use the context while it no longer available

answered Aug 4, 2013 at 5:33

COLD TOLD

13.6k3 gold badges37 silver badges53 bronze badges

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

2 Comments

Pal Over a year ago

So, if I want to know any info about exception, I won't find anything in the first case?

COLD TOLD Over a year ago

you may but second will give you more info

Collectives™ on Stack Overflow

EF(entity framework) "using" statement and "try catch" withing each other

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related