Hi,
Using LINQ to SQL and VB in a 3.5 Framework/Web Project, I want to update a date field (type datetime) in a single record 2005 SQL table. It's a date that I want to persevere for succeedi...
Any example how to read XML to typed DataSet using LINQ? I don't want to use another method, i.e. DataSet.ReadXml() etc. Thanks.
I have a LINQ to SQL in my project. To keep it simple, let's use the linq query below. From this query i get all the projects in my SQL Database.
Dim ProjectQuery = From Projects In Db.Pr...
I want to use the entity framework to call a stored procedure. I created a function import using the designer in visual studio. VmwEwonInterfaceEntities is the name of my model and SpCalacula...
I am trying to create a LinqDataSource that utilizes wild cards. It seems that when creating the where attribute declaretively you can only use == or => or > and similar comparisons. I have ...
In database (SQL Server 2000) I have a table:
CREATE TABLE [dbo].[History] (
[idx] [numeric](18, 0) IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[ssn] [nvarchar] (9) COLLATE SQL_Latin1...
I need to pivot a LINQ Query Result and display it in a DataGridView Control.
I am doing a LINQ to Objects query on an in memory collection..
the query I run in order to retrive the rows...
I am querying an XML file using Linq to XML in order to filter my list. This works fine. However I would like to Group the list by category and order it be category count. When I try to add...
I have a dynamic stored procedure on a database server, and when I execute the procedure using LINQ it returns an int, 0 - 1, successful or not.
How do I get the procedure to return the data,...
Hi Experts,
I need a bit of help please.
I'm trying to convert my LINQ result query to the DataTable.
According to MSDN articles there is a CopyToDataTable () method that's part of Syste...
Hi,
I am having trouble converting the following simple SQL statement into LINQ code (VB):
select * from tblRole r
left outer join tblUserRoles ur
on r.role_id = ur.role_id_f
and ur.u...
Hi,
I have a table with 2 columns
- NAME nvarchar
- PRIORITY int
I need to retrieve the 200 first distinct records from this table, i write the folowing query but it failed with SQL Se...
Hello,
I am trying to update the Linq schema within VS2008 - when I make changes to the underlying Sql database. I have tried using SqlMetal but if I replace the existing .dbml file in my pro...
Hi all,
I'm trying to implement LINQ query on some tables
I have a table called "Raffles", "Orders", "OrderTickets":
Raffles:
-------------------
-ID
-Name
-.......
Orders:
----...
I am binding a DetailsView using Linq in my code-behind form. I have an ItemUpdating event happening which is connected to a typical update button. When I examine e.NewValues.Count in my It...
Hey experts!
I am working on pulling ASP.NET MVC routes from an external file, and it's going well at the moment. My problem is that I want to be able to return the 'controller' attribute f...
Hi,
How to write the below query in LINQ
select * from Booking
inner join bookingoutcome
on booking.uid = bookingoutcome.bookinguid
and bookingoutcome.statusflag ='a'
Thanks in advan...
I've a LINQ query working fine, then if I want to refer to a returned field from that query in LINQ I use something like:
MyObject.FieldName
And that also works fine.
Now: what I nee...
I'm attempting to return an integer based on a matching customer name
{
// get invoice number
InvoiceHeader tOInvHeader = new InvoiceHeader();
oAdm...
I am working through a LINQ sample and get this error from SQL Server 2008.
{"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user...
Hi i have a DataContext where i have tabel called tbl_ingredient.
this table holds alot of values.
however one of the values i need is calculated using some of the other fields.
I tried a...
Hello,
Im trying to write a small client server like application in VB 2008. The server piece will be an Access DB and the client will be a VB 2008 application. I want the VB Application...
I am trying to append/join 2 Linq to SQL querys but am getting the following error:
Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<AnonymousType#1>' to 'System.Data....
I am creating an asp.net (linq to sql) app so user can search list of products by entering keyword. The product are diplayed as images in listview in an item results page. User can click on ...
I'm trying to create a pivot table view of data as you would get in excel but to be displayed in a ultrawingrid.
I have a collection class called PeopleToActivities. This is a collection o...
