Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
646
Grid bound to ObjectDataSource fires full select for every column (LINQ)
posted

 Hi there,

 

I have a Webgrid bound to an ObjectDataSource bound to DataObjects queried with Linq. Everything works fine, except that for every column a whole select statement is fired. See this Trace (I tried to make it more readable, but obviously failed miserably):

---> 

 aspx.page Begin ProcessPostData
 
 SELECT [t0].[StudienGUID], [t0].[StudienID], [t0].[StudienKuerzel], [t0].[StudienNameKurz], [t0].[StudienNameLang], [t0].[StudienNameIntern], [t0].[IsAccessStudy], [t0].[History], [t0].[Version]
FROM [dbo].[Studien] AS [t0]
 -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
 
 SELECT [t0].[StudienGUID], [t0].[StudienID], [t0].[StudienKuerzel], [t0].[StudienNameKurz], [t0].[StudienNameLang], [t0].[StudienNameIntern], [t0].[IsAccessStudy], [t0].[History], [t0].[Version]
FROM [dbo].[Studien] AS [t0]
 -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
 
 SELECT [t0].[StudienGUID], [t0].[StudienID], [t0].[StudienKuerzel], [t0].[StudienNameKurz], [t0].[StudienNameLang], [t0].[StudienNameIntern], [t0].[IsAccessStudy], [t0].[History], [t0].[Version]
FROM [dbo].[Studien] AS [t0]
 -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
 
 SELECT [t0].[StudienGUID], [t0].[StudienID], [t0].[StudienKuerzel], [t0].[StudienNameKurz], [t0].[StudienNameLang], [t0].[StudienNameIntern], [t0].[IsAccessStudy], [t0].[History], [t0].[Version]
FROM [dbo].[Studien] AS [t0]
 -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
 
 SELECT [t0].[StudienGUID], [t0].[StudienID], [t0].[StudienKuerzel], [t0].[StudienNameKurz], [t0].[StudienNameLang], [t0].[StudienNameIntern], [t0].[IsAccessStudy], [t0].[History], [t0].[Version]
FROM [dbo].[Studien] AS [t0]
 -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
 
aspx.page End ProcessPostData

--->

Has someone any idea, how to avoid this??

 

Thanks in advanve and Happy Easter!