Cannot insert a record with Simple.Data

Question

I am using Simple.Data and I receive the following error at the last line when trying to run the code below: An unhandled exception of type 'System.ArgumentException' occurred in System.Core.dll.

    var db = Database.OpenConnection(ConnectionString);
    var product = db.DimDistrict.FindByDistrict("HOUSE");
    //db.FunnelQuotes.Insert(
    //    Company: funnelQuotes[0].Company,
    //    Opportunity: funnelQuotes[0].Opportunity,
    //    QuoteNumber: funnelQuotes[0].QuoteNumber,
    //    QuotedPrice: funnelQuotes[0].QuotedPrice);
    IList<FunnelQuote> retrows = db.FunnelQuotes.Insert(funnelQuotes).ToList();

Note that the commented out code works.

Edit: Added Class Definition

class FunnelQuote
{
    public string Company { get; set; }
    public string Opportunity { get; set; }
    public string QuoteNumber { get; set; }
    public float QuotedPrice { get; set; }
}

Why would you say that funnelQuotes is the wrong argument? What should it be then? — jaromey, Nov 02 '16 at 21:22
Because it is the only Argument in the failing row. I need more information if you need better answer. Show us the FunnelQuotes class could be helpful. — Sebi, Nov 03 '16 at 06:55
I added the class definition. Not much to it. Just a few public properties. Is there a method that I need to implement? I just added the getters and setters and the error is now: "An unhandled exception of type 'Microsoft.CSharp.RuntimeBinder.RuntimeBinderException' occurred in System.Core.dll". — jaromey, Nov 03 '16 at 14:08
Seems to be a problem with dynamic. Please check "Just My Code" in the VS Debugger settings. Extras->Options->Debugging->General->Just My Code. Maybe it's just internal exception which don't affect your program. — Sebi, Nov 03 '16 at 14:29
It is on I believe. For me the path was: Tools >> Options >> Debugging >> General >> "Enable Just My Code". It was already on. I ran the code with and without it. I don't see any difference. — jaromey, Nov 03 '16 at 15:32

score 1 · Accepted Answer · answered Dec 14 '16 at 20:25

Since I couldn't find out why this wasn't working, I ended up just inserting the records one at a time in a foreach loop. However, I have discovered the source of the problem. It was as a result of the field size being too small, e.g., I had an NVARCHAR(10) data type in the database for one of the fields, but one of the rows had greater than 10 characters for that field. It turns out that the foreach loop was just hiding the error by truncating the field. So I thought I'd point out the behaviour of Simple.Data depending on how you do your insert.

Insert with named parameters (I'm assuming it's the same if you insert by object): No error is thrown and the text field is truncated if it is too long.

db.FunnelQuotes.Insert(
    Company: funnelQuotes[0].Company,
    Opportunity: funnelQuotes[0].Opportunity,
    QuoteNumber: funnelQuotes[0].QuoteNumber,
    QuotedPrice: funnelQuotes[0].QuotedPrice
);

Multi-insert without assigning result to a variable: System.InvalidOperationException is thrown with an InnerException that tells you that "String or binary data would be truncated."
```
db.Quotes.Insert(funnelQuotes);
```
Multi-insert, assigning result to a list as shown in the Simple.Data documentation: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException is thrown. The detail is "Cannot perform runtime binding on a null reference". However, in this case the data is still inserted! Any string fields that are too long will be truncated.
```
List<FunnelQuote> retrows = db.Quotes.Insert(funnelQuotes).ToList();
```

Cannot insert a record with Simple.Data

1 Answers1