Forum LINQ to SQL (Pre-Release)

exception while loading xml document from physical location

Thu, 05 Nov 2009 05:18:51 Z

I am getting an exception like this..Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. while loading from physical location from my system.I have given the security permission to the filder,file and also to the directory then also i am getting this error

i have written like this.... XDocument xdoc=XDocument.Load("D:\\Xmlfiles\\programming.xml");

my further code is.. var data = from dataa in xdoc.Descendants("story") where dataa.Element("thumbnail") != null && dataa.Element("thumbnail").Attribute("src").Value.EndsWith(".png") select new UserData { Title = (string)dataa.Element("title").Value, ID = (int)dataa.Attribute("id"), Src = (string)dataa.Element("thumbnail").Attribute("src").Value, UserName = (string)dataa.Element("user").Attribute("name").Value, Topic = (string)dataa.Element("topic").Attribute("name").Value, };

Issue with use of constant expressions and use of Union or Concat

Thu, 10 Sep 2009 16:59:17 Z

There is a known issue with Union and Concat in LINQ to SQL where the use of the same constant value more than once will not produce the expected projection and cause the underlying SQL UNION command to fail. This has been explained as a consequence of early optimization by the query provider and according to Damien Gaurd's thoughtful post this is supposed to be addressed in LINQ to SQL within .NET 4.0. Unfortunately this has been contradicted on this post (ID#355734) on the Microsoft Connect site where a member of the LINQ to SQL team reported "we will not be fixing this in the next release of LINQ to SQL".

Can we get some kind of confirmation on whether this will be addressed in .NET 4.0 and what time frame we are looking at until we will see it come through in public beta's or release candidates?

My only workaround at this point is to use a let statement for every constant that I introduce into my projection for the sake of making my projections similar so that Union and Concat work. Now that I have more than 100 let statements in a particular query I have a feeling that this is contributing to other this other scary TypeLoadException issue that I have just recently began to run into. At this point this bug is affecting my ability to design what is otherwise an elegant data access layer.

Is the 2100 parameter limit when using IEnumerable.Contains() issue going to be addressed

Thu, 10 Sep 2009 18:34:41 Z

Is the 2100 parameter limit when using IEnumerable.Contains() issue going to be addressed in .NET 4.0?

Add, Search, Update, Delete a Record

Tue, 25 Aug 2009 06:31:07 Z

Hello Everybody, I am new to vb.net, i want to Add, Search, Update, Delete a Record on a webserver, add button is to click for saving records, Search record using a Textbox to search, then Display the Data on a textbox or labelbox "Not on a gridview". Update button to update the record as well as for delete button.. thanks in advance...

No LINQ intellisense when targeting Framework 3.5

Sun, 31 May 2009 19:54:38 Z

Hello

I am getting no LINQ intellisense when my project is targeting the 3.5 framework. It compiles succesfully and runs but no intellisense at all on LINQ. When targeting framework 4.0 all is good.

Is there any fix for this?

Thanks,

Problem while adding store procedure to dbml class which returns 2 datatable.

Wed, 19 Aug 2009 12:31:07 Z

i m adding store procedure to dbml class which returns 2 data table.

But in dbml's designer.cs file it takes only first datatable fields.

so is there any way to get 2nd datatable in designer.cs file and display that fields in browser??

i m using sql server 2008 and vs2008 with linq.

thanks in advance for the rpl.

Linq-to-SQL associations being silently ignored under VS2010

Fri, 26 Jun 2009 06:43:27 Z

Hi,

I have a Linq-to-SQL DBML set referencing the SQL Server system views (sys.tables, sys.columns, etc) which was created in fully patched Visual Studio 2008 SP1. I'm pretty sure it worked in 2008, but I can no longer confirm.
I reformatted and installed Windows RC and VS2010. The Associations still exist in the DBML and I can see them on the designer surface, but the generated code does not contain the expected children collection/parent references.

I have other similar DBML sets that work perfectly fine (although they are to tables, not views). If I recreate a sample using just the tables and columns views, I get the same result.
I get no errors or warnings either from 'Run Custom Tool' or building.

Has anyone else had any similar problems or have any suggestions?

find average using linq

Thu, 11 Jun 2009 12:06:25 Z

I have float[] abc = new float[]{10,20,1,80,6,90,78}

I want to find average of 2 elemets each and find minimum of those averages. how can i do that using LINQ in a better way.

I want to do something like following.
for(int i=0;i<abc.length;i++)
{
avg = (abc[0]+abc[1])/2
for(int i=2;i<abc.length;i++)
{
    temp = (abc[i]+abc[i+1])/2
    if(temp<avg)
       avg=temp;
}

}

Beta1 Changes?

Sat, 23 May 2009 02:39:22 Z

I was wondering what changes have been made to the Linq to SQL framework in Beta1? I was playing around with it but I can't seem to find any improvements.

Linq2Sql Shared Common Table causes Entity name conflict when using Dynamic Data

Thu, 21 May 2009 03:43:47 Z

I have project where I am create Linq 2 Sql files for each group of business objects. For this case these groups are People and Users. There is a relationship of a User to Person but a person can stand alone. The issue is that both of these Linq files has a reference to table named dbo.People. When I try to run this project in a Dynamic Data project I get the following error.

The name for entity 'openPlat.Models.PeopleTables.People' in context 'openPlat.Models.PeopleTables.PeopleDataContext' conflicts with the name for the entity 'openPlat.Models.UserTables.People' in context 'openPlat.Models.UserTables.UsersDataContext'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: The name for entity 'openPlat.Models.PeopleTables.People' in context 'openPlat.Models.PeopleTables.PeopleDataContext' conflicts with the name for the entity 'openPlat.Models.UserTables.People' in context 'openPlat.Models.UserTables.UsersDataContext'.

Source Error:


Line 28:             // class in your application.
Line 29:             model.RegisterContext(typeof(openPlat.Models.UserTables.UsersDataContext), new ContextConfiguration() { ScaffoldAllTables = true });
Line 30:             model.RegisterContext(typeof(openPlat.Models.PeopleTables.PeopleDataContext), new ContextConfiguration() { ScaffoldAllTables = true });
Line 31: 
Line 32:             // The following statement supports separate-page mode, where the List, Detail, Insert, and

Source File: H:\Users\Owner\Documents\Visual Studio 2008\Projects\openPlat\openPlat\Global.asax.cs Line: 30

Stack Trace:


[ArgumentException: The name for entity 'openPlat.Models.PeopleTables.People' in context 'openPlat.Models.PeopleTables.PeopleDataContext' conflicts with the name for the entity 'openPlat.Models.UserTables.People' in context 'openPlat.Models.UserTables.UsersDataContext'.]
   System.Web.DynamicData.MetaModel.CheckTableNameConflict(MetaTable table, String nameOverride, List`1 tablesToInitialize) +159679
   System.Web.DynamicData.MetaModel.RegisterContext(DataModelProvider dataModelProvider, ContextConfiguration configuration) +758
   System.Web.DynamicData.MetaModel.RegisterContext(Func`1 contextFactory, ContextConfiguration configuration) +359
   System.Web.DynamicData.MetaModel.RegisterContext(Type contextType, ContextConfiguration configuration) +79
   openPlat.Global.RegisterRoutes(RouteCollection routes) in H:\Users\Owner\Documents\Visual Studio 2008\Projects\openPlat\openPlat\Global.asax.cs:30
   openPlat.Global.Application_Start(Object sender, EventArgs e) in H:\Users\Owner\Documents\Visual Studio 2008\Projects\openPlat\openPlat\Global.asax.cs:59

[InvalidOperationException: An error occurred during model registration and this operation cannot be performed.]
   System.Web.DynamicData.MetaModel.CheckForRegistrationException() +160119
   System.Web.DynamicData.MetaModel.get_Default() +4
   openPlat._Default.Page_Load(Object sender, EventArgs e) in H:\Users\Owner\Documents\Visual Studio 2008\Projects\openPlat\openPlat\Default.aspx.cs:21
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Any advice on how to handle using a table in multiple Linq 2 Sql files would be greatly appreciated.