title: Add record to an SQL Azure table using LINQ where ID is "identity (auto_increment)"
body: <p>I am trying to pass a LINQ query in my Service1.svc.cs to add a new Asset which is an entity in my SQL Azure database. Also AstID is the PK and is set as identity in SQL Azure</p>
  
  <p>I have an <code>OperationContract</code> as follows in my IService1.cs</p>
  
  <pre><code>[OperationContract]
  void AddAsset(string AstName, string AstCondition);
  </code></pre>
  
  <p>and the following void in my Service1.cs</p>
  
  <pre><code> public void AddAsset(string AstName, string AstCondition)
          {
              DataClasses1DataContext context = new DataClasses1DataContext();
              Asset AssetObj = new Asset();
              AssetObj.AstName = AstName;
              AssetObj.AstCondition = AstCondition;
              context.Assets.InsertOnSubmit(AssetObj);
              context.SubmitChanges();        
          }
  </code></pre>
  
  <p>In my Client Application, where i'm consuming the WCF Service, i have the following:</p>
  
  <pre><code>public void AddAssetQuery(string AstName, string AstCondition)
          {
              Service1Client proxy = new Service1Client();
              proxy.AddAssetCompleted += (proxy_AddAssetCompleted);
              proxy.AddAssetAsync(AstName, AstCondition);
  
          }
  </code></pre>
  
  <p>and</p>
  
  <pre><code>private void btnAdd_Click(object sender, RoutedEventArgs e)
          {
  
              AddAssetQuery("Dell PC","Mint");
  
          }
  </code></pre>
  
  <p>I also have a Completed void, wherein i have a MessageBox that notifies me that the action was completed. Even though, when i check my SQL Azure databse, no data is being fed. Any ideas, why?</p>