linq-to-sqlcode-generationlinqpad
Is it possible to change LINQPad code generation on XML type?
In SQL Server a table can have a XML column
CREATE TABLE [dbo].[Temp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[C1] [xml] NULL
)
XML column allows multiple root content, it's legal to put below into xml column
<a>1</a><a>2</a>
When doing query, I got this error,
There are multiple root elements
I think the cause of the error is CLR data type LINQPad/Linq-to-SQL auto-generated.
public XElement C1;
XElement does not allow multiple root content.
Is it possible to intervene the code generation process, so change the data type as string?
public String C1;
btw, the assembly LinqPad generated is at
Solution
Yes, use the advanced properties on the SQL Connection dialog to map XML columns to string.
- Can't drag stored procedure onto dbml designer
- How do I get the MAX row with a GROUP BY in LINQ query?
- Difference Between Select and SelectMany
- How to convert IEnumerable type to List type?
- How to do Select All(*) in linq to sql
- How can I enable Transaction my codes with linqto SQL?
- Why is the `AND f.otherid = 17` condition part of the JOIN instead of in the WHERE clause?
- HierarchyID: Get all descendants for a list of parents using LINQ-to-SQL
- LINQ - Left Join, Group By, and Count
- Dynamic Linq query options
- Passing list to Linq query
- linq to sql loadwith vs associatewith
- Can I add a linq compiler to my project?
- 'CompanyName.Foo' is a 'namespace' but is used like a 'type'
- linq2sql: Cannot add an entity with a key that is already in use
- What is the syntax for an inner join in LINQ to SQL?
- Anonymous Type in LINQ
- Linq to SQL generic paging method confusion
- Linq & Paging - Unable to return paged data with an OrderBy
- How can I page my LINQ to SQL result set?
- Get the total number of records when doing pagination
- Linq to SQL provides different results when using TOP and Between
- My Linq to SQL query paging logic is not executing in the database
- XDocument.Save() without header
- Linq to SQL: how to aggregate without a group by?
- Is it true that I can still use Linq to SQL in design time even if you are targeting .net 2 in your application?
- TotalRowCount with paging in Linq2SQL
- Paging using Linq-To-Sql based on two parameters in asp.net mvc
- How to do datalist paging using linq to sql and datalist in asp 3.5?
- LINQ to SQL and DataPager