LINQ in Action roller

Linq to Sql.Where is Linq to Oracle :(

MSDN Forums: LINQ Project General — Tue, 14 Oct 2008 01:05:49 GMT

I came across this site at http://forums.oracle.com/forums/thread.jspa?threadID=547266&start=0&tstart=0 And i saw posts of Developers grumbling about Oracle not supporting LINQ Any ideas? Oracle pls wake up. Read More......(read more)

Help On linqdatasource when update using stored proc after selecting from stored proc

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 12:25:16 GMT

Hi all, First off im a newbie to linq so please be kind! I have a datacontext class with tables on but more importantly it has 2 stored procedures on it 1 to get and 1 to update a table. The problem: On my form i have a datagrid with the datasourceid set to be a linqdatasource. The linqdatasource is assigned to my context class but i cant set tablename as i want to use a stored proc which i do on the selecing method all works fine so far and result as displayed in my grid. Now the problem is as i...(read more)

Trying to understand the advantage of LINQ's "Update Check" always vs when changed values.

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 07:39:19 GMT

Each column in LINQ tables have property called " Update Check " for optimisitc concurrency. Any real benefit of choosing Always vs When Changed? Seems that if you choose "Always" it will be a performance drag b/c regardless of which field is changed on the table, any fields where "Update Check=Always" will always have to validate if a concurrency issues exist. Its almost better to choose "When changed" instead of Always correct right? If not please explain... Thanks! Read More......(read more)

Why is the advanced button grayed out when configuring LINQDataSource

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 07:14:59 GMT

I noticed something odd when I add a new LINQDataSource on my page. When I configure the datasource, and check 2 or 3 fields, my advance button is grayed out and not available to select "Enable the LinqDataSource to perform automatic deletes, inserts, updates". When I click the * field for all fields, then the "Advanced" button is enabled and I can check the 3 options I just mentioned. Can someone explain why this happens? often times I don't want to return all fields, but want LINQ to handle my...(read more)

Where is the submitChange() when you click Update or Delete on a GridView

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 07:10:11 GMT

I have a gridview where I use a LINQDataSource to retrieve my data and populate the grid. I checked the 3 checkboxes allowing the linqdatasource to handle my inserts, deletes, updates, thus creating the Edit, Delete, Select hyperlink on the very first column of the grid. When I click on "Update" once I'm in EditMode, where or how does the "SubmitChange() get called from? Read More......(read more)

LINQ Optmistic Concurrency confusion between SubmitChanges(ConflictMode options).

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 06:19:59 GMT

Hi everyone, I'm trying to get more familiar with LINQ Optimistic Concurrency. I'm having trouble identifying where to specify which conflictMode you want for your submit change and the difference between FailOnFirstConflict and ContinueOnConflict? I have a data grid, where I let LINQ handle my updates and deletes...so i don't really call the submitChange() method like the examples in the linq above. So I decided to change the SubmitChanges base class, in the NorthinWindDataContext partial class...(read more)

Joining Many to Many with LINQ

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 06:01:31 GMT

Hi, I'm new to LINQ and am still not really able to translate the way I would write SQL to efficient LINQ queries. The instance that keeps coming up is when trying to get data from tables that have a many to many relationship with a linking table in between. Here's an example: Code Snippet tbl_Owners ------------------- pk_ownerID name tbl_WidgetOwners -------------------------- fk_ownerID fk_widgetID tbl_Widgets ------------------- pk_widgetID isSpecial I get pretty confused on how to use LINQ to...(read more)

Try to make a generic historical method with linq

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 05:56:51 GMT

Good afternoon I am trying to make a generic query in linq to get only the newests record in my database, whit the answers i get in this forum, i desing a interface to be implemented in the classes generate by linq, but is not working, please somebody colud help me in put this to work I am getting this error Error 1 The type 'T' must be a reference type in order to use it as parameter 'TEntity' in the generic type or method 'System.Data.Linq.Table' C:\Projetos\SyncSAT\SyncSAT\Dao\Historico.cs 10...(read more)

Filter Data using range of letters or numbers

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 05:28:38 GMT

hi all, Question here, It is any way to code this using LINQ in order to use BETWEEN sql statement How can i use the function below in a LINQ? 'ASCII(SUBSTRING(UPPER(CustomerName), 0, 1)) Between 65 And 76" Thanks so much Jorge Read More......(read more)

InsertOnSubmit and SubmitChanges. Nothing happens but no error.

MSDN Forums: LINQ Project General — Mon, 13 Oct 2008 03:25:41 GMT

Hello all. I've posted this also in the SQLCE forum but it seems this one has more activity :) I'm working on my first project with SQLCE in VB2008 with Visual Studio 2008. I have a database (.sdf) and i used SQLMetal to generate the dbml using the command: "sqlmetal /dbml:EMCANData.dbml Data.sdf /context:EMCANDatacontext /pluralize" to insert something in a table I use the same syntax that worked well in SQL Server. For the example I use the "Festivo" table that has 3 columns (Id primary key identity...(read more)

Using LINQ to XML Events and Annotations to Track if an XML Tree has Changed

Eric White's Blog — Sun, 12 Oct 2008 10:54:00 GMT

You may optionally be making a number of modifications to a very large XDocument object. Because of a complicated algorithm, you may not necessarily know ahead of time whether you will be making changes. If you don’t make any changes, then you don’t want to unnecessarily serialize the tree and save it to disk, or send it over the wire. This post presents a simple technique to determine if an XDocument has ever been modified since deserialization or creation. For example, you might have a very large...(read more)

Do an Insert from the Array using LINQ to SQL

MSDN Forums: LINQ Project General — Sun, 12 Oct 2008 03:10:58 GMT

Hello, I have an array with over 300 fields to be inserted into SQL. Trying to use LINQ to SQL, but the problem is I can not find a way to loop through Linq object which was created by dragging table. Basically For Each rowField In allRows If rowField.Length > 1 Then allfields = rowField.Split(vbTab) 'fields 'process-insert into SQL Dim newRecord As New Elements newRecord.id= allfields(0) newRecord.name = allfields(1) newRecord.city = allfields(2) ........ here goes 300 more rows which I really don't...(read more)

microsoft.visualstudio.shell.interop.iselection

MSDN Forums: LINQ Project General — Sat, 11 Oct 2008 11:10:36 GMT

please i am having this error anytime i want to open the design interface, " microsoft.visualstudio.shell.interop.iselection container already exist in the service container. also for my data class design i am having this system.componentmodel not defined. although i just upgraded my operating system to Microsoft vista ultimate, can it be that it has destroyed some of my registry files? please can someone help me out? any help will do. thank you. Read More......(read more)

Visual Studio Industry Partner Program

Eric White's Blog — Sat, 11 Oct 2008 10:06:00 GMT

Microsoft offers a partner program for companies that sell tools and products that either integrate into or complement Microsoft’s developer offerings. This program provides remarkable value. If you are a company that produces a product (or products) for developers that either integrate with or extend Visual Studio you should sit up and take notice! This includes all of you folks who produce development products for SharePoint. Disclaimer - I have no personal vested interest in people joining this...(read more)

troubles with transactions and LINQ inserts

MSDN Forums: LINQ Project General — Sat, 11 Oct 2008 10:03:01 GMT

I'm trying to solve the classic problem where I have record I want to insert in a table, then the next insert depends on the identity of the first. That is, I have an Address Table and a CompanyAddress Table. I first insert into the address table, then, taking the identity column from that insert, I insert in my CompanyAddress Table. I want to have these inserts in a transaction so if second one fails, orphaned address record gets rolled back. Problem is, if I call db.SubmitChanges();, that starts...(read more)