LINQ to SQL DataContext connection error reporting

Question

Okay, so I have this LINQ to SQL situation. I have a DataContext object which links to an SQL database and I can get tables and... all of that business. This is all inside a WCF service inside IIS.

Now I connect the DataContext object when I declare it, which is at the top of the class, as follows:

DataContext dc = new DataContext([ConnectionString]);

Then, later, I have methods to do things like inserting a Client (that is a type of entity), and that looks something like this:

public void InsertClient(Client client)
{
   if(client.ClientID > 0)
      return;

   dc.Clients.InsertOnSubmit(client);

   dc.SubmitChanges();
}

The problem is basically... is there some way to test that connection? What if someone pulled a plug or something before SubmitChanges? It's not like it returns anything, so it couldn't tell me there was a particular error.

How would people recommend I do this?

Thanks.

jason · Accepted Answer · 2011-12-09 16:18:14Z

4

DataContext.SubmitChanges will throw if there is an error.

answered Dec 9, 2011 at 16:18

jason

243k36 gold badges437 silver badges532 bronze badges

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

1 Comment

Joe Over a year ago

Probably something like A network-related or instance-specific error occurred while establishing a connection to SQL Server

Ali Foroughi · Accepted Answer · 2011-12-10 10:55:31Z

1

public bool InsertClient(Client client)
{
   if(client.ClientID > 0)
      return;

   dc.Clients.InsertOnSubmit(client);

   try
   {
      dc.SubmitChanges();
      return true;
   }
   catch
   {
        return false;
   }
}

answered Dec 10, 2011 at 10:55

Ali Foroughi

4,6097 gold badges45 silver badges67 bronze badges

Comments

Pleun · Accepted Answer · 2011-12-10 10:51:09Z

0

Well, the datacontext has the public DataContext.Connection Property so if you want you can do anything you want with it...

But I do not think that is particually usefull since Submitchanges anyway will throw like is written in the other answer.

answered Dec 10, 2011 at 10:51

Pleun

8,9102 gold badges33 silver badges51 bronze badges

Collectives™ on Stack Overflow

LINQ to SQL DataContext connection error reporting

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related