We can use LINQ to SQL queries for fetching the
records and filtering them. We can also bind the controls to the data source that is
created using the objects built by the designer.
Choose the menu option Data, and then Add New Data Sources. From the selected
data sources select the Object option and click on the Next button.
LINQ to SQL
[ 130 ]
In the next window, select the Category entity table to add the corresponding
data source and then click on the Finish button, so that the data source gets added
to the project.
You can add as many entities to the project as you need in the application. Now open
the windows form and open the available Data Sources list in the project using the
Data Sources explorer.
Chapter 4
[ 131 ]
Now open Form1.cs [Design]. Select the Data menu option, then Show Data Sources
which will open the Data Sources explorer and display the Category data source
that we created. You can see a drop-down next to the Category data source name
which gives two options??”Details and DataGridView.
Pages:
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213