I'll also show how we can cleanly integrate business rules and custom validation logic with our data model.
In Part 2 of this series I walked through how to create a LINQ to SQL class model using the LINQ to SQL designer that is built-into VS 2008.
Below is a class model created for the Northwind sample database and which I'll be using in this blog post: When we designed our data model using the LINQ to SQL data designer above we defined five data model classes: Product, Category, Customer, Order and Order Detail.
João Pinto I actually looked up the ACCESS keywords, and Password wasn't one of them. NET: Part 1/2" and "All You Need To Know About ADO. I used to rock and roll every night and party every day. Now I'm lucky if I can find 30 minutes a week in which to get funky. Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Oh, also, try removing the parentheses from around the where clause:"' WHERE (User= '" & Utilizador & "')"becomes"' WHERE User= '" & Utilizador & "'" I used to rock and roll every night and party every day. Now I'm lucky if I can find 30 minutes a week in which to get funky. Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! NET Code The articles titled "All You Need To Know About ADO. João Pinto Okay, the only other thing I can think of right now: Is there an apostrophe in either the password or the username you are using? Open()s SQL = "SELECT * FROM [Utilizadores] WHERE (User= '" & Utilizador & "')"da = New Ole Db. I've tryed to do what you told me on access but I didn't got more information about the error. OLEDB.4.0;" & "Data Source=""C:\Programaçao\Visual Basic\Inapal\Report It\Report It.mdb"";"con. Fill(ds, "Utilizadores")s SQL = "UPDATE Utilizadores SET Password='" & New Password Txt Bx. Even tryed to use the code provided by you for update throught dataset/dataadapter but I get the same sintax error message.