converting a string to an acceptable SQL value

Question

I have a difficulty in parsing user input to a variable in an SQL sproc. I'm using linq as a go-between.

My web form contains, amongst other things, a textbox for a user to input a search parameter. This content has to be parsed from Text to a string, and subsequently to a char of 16 length. The data in the table that I am looking at is a char of the same length.

So, I tried the following:

public void GetASingleInvoice(string invoiceNumber)
    {
        char iNum = Convert.ToChar(invoiceNumber);

        var invoice = from SIMS_InvoiceNo in financedb.INVOICEs
                      where SIMS_InvoiceNo = iNum
                      select SIMS_InvoiceNo;
    }

but iNum at line 6 has a beautiful squiggly line, telling me I cannot convert type "char" to
"(corporatepath).Models.INVOICE".

Have I broken linq?
I have the class for invoice here: http://pastebin.com/da6PJxn6

Edit: I have also tried the double operator (==) which results in an error specifying that a single operator is to be used here.

Note: Changing the type of the column in SQL is not an option.

It's funny to see how all copy-paste ` = iNum` in their answers :) — Sergey Berezovskiy
– Sergey Berezovskiy, Commented May 29, 2014 at 11:35

Sergey Berezovskiy · Accepted Answer · 2014-05-29 11:40:13Z

2

You need to specify the property of the INVOICE class like this:

var invoices = from invoice in financedb.INVOICEs
              where invoice.SIMS_InvoiceNo == iNum
              select invoice;

edited May 29, 2014 at 11:40

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

answered May 29, 2014 at 11:32

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

1 Comment

user3560094 Over a year ago

If I use this, it results in a definition error - INVOICE does not contain a definition for invoiceNumber. Do you mean to imply that I should put a definition for invoiceNumber in ~.Invoice?

Ehsan Sajjad · Accepted Answer · 2014-05-29 11:45:38Z

1

you have missed to provide the column:

 var invoice = from Invoice in financedb.INVOICEs
         ----> where Invoice.SomeProperty == iNum
               select Invoice;

Also in linq where you need == not =

edited May 29, 2014 at 11:45

answered May 29, 2014 at 11:33

Ehsan Sajjad

62.6k16 gold badges113 silver badges171 bronze badges

Comments

Sergey Berezovskiy · Accepted Answer · 2014-05-29 11:37:52Z

0

Correct query:

var invoices = from i in financedb.INVOICEs
               where i.SIMS_InvoiceNo == iNum
               select i;

Or if you want single invoice by number, then simply use FirstOrDefault or SingleOrDefault methods:

var invoice = financedb.INVOICEs.FirstOrDefault(i => i.SIMS_InvoiceNo == iNum);

answered May 29, 2014 at 11:37

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

2 Comments

Sergey Berezovskiy Over a year ago

@RoteKatze btw if you'll switch to Entity Framework (which I suggest to do, if its possible), there is even more handy method Find, and getting entity by key looks like financedb.INVOICEs.Find(iNum)

user3560094 Over a year ago

I plan to with future projects, but this system is being decommissioned soon. This is only a small intranet program to visually compare finances :)

Collectives™ on Stack Overflow

converting a string to an acceptable SQL value

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related