Blinq Preview (RETIRED)http://forums.asp.net/1076.aspx/1?Blinq+Preview+RETIRED+Blinq is a tool for generating ASP.NET websites for displaying, creating, and manipulating data based on database schema. You can provide feedback and ask questions about the Blinq preview in this forum. Note : This forum was retired on Monday July 12, 2010, and is now read-only. More InformationFri, 30 Oct 2009 13:29:31 -0400urn:uuid:00000000-0000-0000-0000-000000001076urn:uuid:00000000-0000-0000-0000-000003485951http://forums.asp.net/p/1487273/3485951.aspx/1?Newbie+question+here+how+do+you+run+it+Newbie question here...how do you run it? <p>Kind of a Newbie question here...but how&nbsp;do you&nbsp;run blinq&nbsp;once you install it?&nbsp;&nbsp;I&nbsp;&nbsp;ran the install, it said it completed successfully, but it didn't add anything to my Start Menu program list, nor do I see any new menus inside Visual Studio 2005.&nbsp; I tried to run Blinq command lines from cmd and from Run, but it just said that Blinq was unrecognized.&nbsp; I'm doing a search of c:\ now to see if there are any files with &quot;Blinq&quot; in the name.&nbsp; So far, nothing has turned up.</p> 2009-10-30T15:57:45-04:002009-10-30T15:57:45.127-04:00urn:uuid:00000000-0000-0000-0000-000001368781http://forums.asp.net/p/1016914/1368781.aspx/1?Row+not+found+or+changedRow not found or changed <p>I've been playing around with Blinq today and everything was working fine until I decided to add a few more relationships in my database and then rerun blinq. Now when ever I try to update a record in any of the tables I get the ROW NOT FOUND OR CHANGED error. I realize there is a way to turn off the optimistic concurrency check, but I'm just wondering why it's necessary and why it suddenly occured after adding some simple relationships.</p> <p>Just trying to understand the process a little better. Thanks.</p> <p>My stack trace is below:</p> <p>OptimisticConcurrencyException: Row not found or changed.]<br> &nbsp;&nbsp; System.Data.DLinq.ChangeProcessor.ThrowOptimisticConcurrencyException(List`1 failedUpdates, Int32 totalUpdatesAttempted) &#43;171<br> &nbsp;&nbsp; System.Data.DLinq.ChangeProcessor.SubmitChanges(ConflictMode failureMode) &#43;522<br> &nbsp;&nbsp; System.Data.DLinq.DataContext.SubmitChanges(ConflictMode failureMode) &#43;229<br> &nbsp;&nbsp; System.Data.DLinq.DataContext.SubmitChanges() &#43;6<br> &nbsp;&nbsp; TblOffice.Update(TblOffice original_x, TblOffice x) in c:\inetpub\wwwroot\TL\App_Code\StaticMethods.vb:462<br> <br> [TargetInvocationException: Exception has been thrown by the target of an invocation.]<br> &nbsp;&nbsp; System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) &#43;0<br> &nbsp;&nbsp; System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) &#43;72<br> &nbsp;&nbsp; System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) &#43;358<br> &nbsp;&nbsp; System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) &#43;29<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object&amp; instance) &#43;482<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method) &#43;38<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) &#43;2573<br> &nbsp;&nbsp; System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) &#43;78<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) &#43;1215<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) &#43;858<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) &#43;95<br> &nbsp;&nbsp; System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) &#43;35<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) &#43;117<br> &nbsp;&nbsp; System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) &#43;35<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) &#43;115<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) &#43;163<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) &#43;7<br> &nbsp;&nbsp; System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) &#43;11<br> &nbsp;&nbsp; System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) &#43;174<br> &nbsp;&nbsp; System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) &#43;5102<br> </p> 2006-08-11T20:34:06-04:002006-08-11T20:34:06.593-04:00urn:uuid:00000000-0000-0000-0000-000002773028http://forums.asp.net/p/1354184/2773028.aspx/1?How+do+I+integrate+GUI+for+BLINQ+or+blinqGUI+as+it+is+called+in+Visual+Studio+2008+How do I integrate GUI for BLINQ or blinqGUI as it is called in Visual Studio 2008? <p>Hello,</p> <p>How do I integrate GUI for BLINQ or blinqGUI as it is called in Visual Studio 2008 for Web Site development?</p> 2008-11-28T09:45:42-05:002008-11-28T09:45:42.703-05:00urn:uuid:00000000-0000-0000-0000-000002684516http://forums.asp.net/p/1334276/2684516.aspx/1?GenericMethodDefinition+MakeGenericMethod+may+only+be+called+on+a+method+for+which+MethodBase+IsGenericMethodDefinition+is+true+GenericMethodDefinition. MakeGenericMethod may only be called on a method for which MethodBase.IsGenericMethodDefinition is true. <p>I generated a Blinq site for the Northwind DB. The site was created successfully and most of the links and functionality work as expected however I am getting an error when I try to go to view the details of any individual record. Following is the error I get when I try to view the details of a Product. Any help will be highly appreciated. Thanks: </p> <span></span><span> <h1>Server Error in '/Northwind' Application. <hr width="100%" color="silver" size="1"> </h1> <h2><i>System.Query.IQueryable`1[Product&#43;_Anonymous_GetProductsByCategory_2C9_12] Select[Product,_Anonymous_GetProductsByCategory_2C9_12](System.Query.IQueryable`1[Product], System.Expressions.Expression`1[System.Query.Func`2[Product,Product&#43;_Anonymous_GetProductsByCategory_2C9_12]]) is not a GenericMethodDefinition. MakeGenericMethod may only be called on a method for which MethodBase.IsGenericMethodDefinition is true.</i> </h2> <p></span><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><b>Description: </b>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. <br> <br> <b>Exception Details: </b>System.InvalidOperationException: System.Query.IQueryable`1[Product&#43;_Anonymous_GetProductsByCategory_2C9_12] Select[Product,_Anonymous_GetProductsByCategory_2C9_12](System.Query.IQueryable`1[Product], System.Expressions.Expression`1[System.Query.Func`2[Product,Product&#43;_Anonymous_GetProductsByCategory_2C9_12]]) is not a GenericMethodDefinition. MakeGenericMethod may only be called on a method for which MethodBase.IsGenericMethodDefinition is true.<br> <br> <b>Source Error:</b> <br> <br> <table class="" width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td class=""><pre class="prettyprint"><pre>Line 709: Where x.CategoryID = CategoryID _</pre> Line 710: Select x.Products Line 711: Return From y In result, z In y _ Line 712: Select z Line 713: End Function <pre></pre></pre></TD></TR></TBODY></TABLE><BR><B><FONT face=Verdana>Source File: </FONT></B>c:\Northwind\App_Code\StaticMethods.vb<B><FONT face=Verdana> &nbsp;&nbsp; Line: </FONT></B>711 <BR><BR><B><FONT face=Verdana>Stack Trace:</FONT></B> <BR><BR> <TABLE class="" width="100%" bgColor=#ffffcc> <TBODY> <TR> <TD class=""><pre class="prettyprint"><PRE>[InvalidOperationException: System.Query.IQueryable`1[Product+_Anonymous_GetProductsByCategory_2C9_12] Select[Product,_Anonymous_GetProductsByCategory_2C9_12](System.Query.IQueryable`1[Product], System.Expressions.Expression`1[System.Query.Func`2[Product,Product+_Anonymous_GetProductsByCategory_2C9_12]]) is not a GenericMethodDefinition. MakeGenericMethod may only be called on a method for which MethodBase.IsGenericMethodDefinition is true.] System.Reflection.RuntimeMethodInfo.MakeGenericMethod(Type[] methodInstantiation) +2343068 Product.GetProductsByCategory(Int32 CategoryID) in c:\Northwind\App_Code\StaticMethods.vb:711 Product.GetFilteredProducts(String tableName, Int32 Products_CategoryID, Int32 Products_SupplierID) in c:\Northwind\App_Code\StaticMethods.vb:735 Product.GetProducts(String tableName, Int32 Products_CategoryID, Int32 Products_SupplierID, String sortExpression, Int32 startRowIndex, Int32 maximumRows) in c:\Northwind\App_Code\StaticMethods.vb:727 [TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +371 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object&amp; instance) +480 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1960 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041 </PRE></pre></td> </tr> </tbody> </table> </font></p> 2008-10-15T13:30:45-04:002008-10-15T13:30:45.737-04:00urn:uuid:00000000-0000-0000-0000-000002558422http://forums.asp.net/p/1305629/2558422.aspx/1?Blinq+s+place+in+the+worldBlinq's place in the world <p>It would really be cool if someone could write a paper with guidance on how to make usage distinctions between all these great new frameworks Microsoft is developing. Right now my mind is boggled trying to grok ASP.NET MVC, Dynamic Data, Subsonic and umpteen other new gems, <em>all coming from the ASP team</em>! The problem spaces for these new things are so similar, I for one could use a pre-digested comparison analysis.</p> <p>&nbsp;</p> <p>Thanks,</p> <p>Jeff</p> 2008-08-14T17:12:03-04:002008-08-14T17:12:03.297-04:00urn:uuid:00000000-0000-0000-0000-000002033203http://forums.asp.net/p/1188220/2033203.aspx/1?Using+blinq+with+Visual+Studio+2008+RTMUsing blinq with Visual Studio 2008 RTM <p>Any idea when blinq will support VS 2008 RTM?&nbsp; I tried it today and I get the following error message when I try to run blinq.exe:</p> <p>Error: May Linq CTP is not installed or configured correctly. You can download it from http://msdn.microsoft.com/data/ref/linq/ If you are running Blinq from a command window, close it and open a new one after installing the Linq Preview.</p> <p>Or is there a way to work around this?<br> &nbsp;</p> 2007-11-29T18:39:38-05:002007-11-29T18:39:38.103-05:00urn:uuid:00000000-0000-0000-0000-000001360991http://forums.asp.net/p/1014502/1360991.aspx/1?Getting+the+Identity+of+the+last+Inserted+row+Getting the Identity of the last Inserted row! <p>Can anyone tell me how to get the identity of the last inserted row? I'm using DLINQ so please don't tell me how to do this in SQL as I know this. In SQL I would use SCOPE_IDENTITY() or @@IDENTITY (generally not the latter)</p> <p>Please help! I have project to be finished ASAP and this is the only bit holding me back!</p> <p>Thanks !</p> <p>&nbsp;</p> 2006-08-04T10:16:25-04:002006-08-04T10:16:25.437-04:00urn:uuid:00000000-0000-0000-0000-000001387132http://forums.asp.net/p/1022798/1387132.aspx/1?AdventureWorks+Database+error+updating+an+existing+row+AdventureWorks Database - error updating an existing row. <p>To reproduce thsi simple install the Aventure works database, run blinq, go to 'ScrapReasons table, edit row 7, update....kabam!</p> <p>&nbsp;Any ideas???</p> <p>Guess&nbsp;some testing needed against other databases (besides Northwind) ?&nbsp;</p> <p>&nbsp;Row not found or changed. <br> 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. </p> <p>Exception Details: System.Data.DLinq.OptimisticConcurrencyException: Row not found or changed.</p> <p>Source Error: </p> <p><br> Line 1091:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; original_x.Name = x.Name;<br> Line 1092:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; original_x.ModifiedDate = x.ModifiedDate;<br> Line 1093:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.SubmitChanges();<br> Line 1094:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return 1;<br> Line 1095:&nbsp;&nbsp;&nbsp; }<br> &nbsp;</p> <p>Source File: c:\blinqtest\App_Code\StaticMethods.cs&nbsp;&nbsp;&nbsp; Line: 1093 </p> <p>Stack Trace: </p> <p><br> [OptimisticConcurrencyException: Row not found or changed.]<br> &nbsp;&nbsp; System.Data.DLinq.ChangeProcessor.ThrowOptimisticConcurrencyException(List`1 failedUpdates, Int32 totalUpdatesAttempted) &#43;182<br> &nbsp;&nbsp; System.Data.DLinq.ChangeProcessor.SubmitChanges(ConflictMode failureMode) &#43;620<br> &nbsp;&nbsp; System.Data.DLinq.DataContext.SubmitChanges(ConflictMode failureMode) &#43;264<br> &nbsp;&nbsp; System.Data.DLinq.DataContext.SubmitChanges() &#43;25<br> &nbsp;&nbsp; ScrapReason.Update(ScrapReason original_x, ScrapReason x) in c:\blinqtest\App_Code\StaticMethods.cs:1093</p> <p>[TargetInvocationException: Exception has been thrown by the target of an invocation.]<br> &nbsp;&nbsp; System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) &#43;0<br> &nbsp;&nbsp; System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) &#43;72<br> &nbsp;&nbsp; System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) &#43;358<br> &nbsp;&nbsp; System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) &#43;29<br> &nbsp;&nbsp; System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) &#43;17<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object&amp; instance) &#43;676<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method) &#43;60<br> &nbsp;&nbsp; System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) &#43;2319<br> &nbsp;&nbsp; System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) &#43;179<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) &#43;1138<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) &#43;835<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) &#43;162<br> &nbsp;&nbsp; System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) &#43;56<br> &nbsp;&nbsp; System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) &#43;118<br> &nbsp;&nbsp; System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) &#43;56<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) &#43;107<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) &#43;175<br> &nbsp;&nbsp; System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) &#43;31<br> &nbsp;&nbsp; System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) &#43;32<br> &nbsp;&nbsp; System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) &#43;244<br> &nbsp;&nbsp; System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) &#43;3839</p> <p>&nbsp;</p> 2006-09-01T13:44:21-04:002006-09-01T13:44:21.25-04:00urn:uuid:00000000-0000-0000-0000-000002188721http://forums.asp.net/p/1223407/2188721.aspx/1?Is+Blinq+stable+Is Blinq stable? When will Blinq be considered stable/code complete? Is this a tool that is ready for production? Thanks, chris 2008-02-22T00:04:13-05:002008-02-22T00:04:13.39-05:00urn:uuid:00000000-0000-0000-0000-000002169273http://forums.asp.net/p/1218958/2169273.aspx/1?Linq+not+working+after+changing+connectionstring+to+host+databaseLinq not working after changing connectionstring to host database <p>Dear</p> <p>On my local IIS everything is working, but when I change the connectionstring to remote database I get following error, although tables, storprocs etc. are equal on host (also tested using a sql datasource control):</p> <p><strong>Description: </strong>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. <br> <br> <b>Exception Details: </b>System.Data.SqlClient.SqlException: Invalid object name 'MyStats.dbo.MuscleGroup'.<br> <br> <b>Source Error:</b> <br> <br> <table class="" width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td class=""><pre class="prettyprint"><pre>Line 66: public int GetMuscleGroups()</pre> Line 67: { Line 68: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod()))); Line 69: return ((int)(result.ReturnValue)); Line 70: <pre></pre></pre></td> </tr> </tbody> </table> </p> <p><strong>Source File: </strong>c:\x\dataclasses1.designer.cs<b> &nbsp;&nbsp; Line: </b>68 </p> 2008-02-12T21:26:57-05:002008-02-12T21:26:57.097-05:00urn:uuid:00000000-0000-0000-0000-000002127816http://forums.asp.net/p/1209682/2127816.aspx/1?Execption+thrown+while+insertion+and+editExecption thrown while insertion and edit <p>I have created a web application using Blinq.<br> </p> <p>When I m inserting a record it is giving me following exception :</p> <p>{&quot;Cannot access a disposed object.\r\nObject name: 'Transaction'.&quot;}</p> <p>Following is the stack trace:&nbsp;</p> <p>&quot; at System.Transactions.Transaction.get_TransactionInformation()\r\n at System.Data.DLinq.DataContext.OnTransactionCompleted(Object sender, TransactionEventArgs args)\r\n at System.Data.DLinq.SqlClient.SqlContext.RaiseTransactionCompleted(TransactionEventArgs args)\r\n at System.Data.DLinq.SqlClient.SqlConnectionManager.b__0(Object sender, TransactionEventArgs args)\r\n at System.Transactions.TransactionCompletedEventHandler.Invoke(Object sender, TransactionEventArgs e)\r\n at System.Transactions.InternalTransaction.FireCompletion()\r\n at System.Transactions.TransactionStatePromotedCommitted.EnterState(InternalTransaction tx)\r\n at System.Transactions.TransactionStatePromotedBase.ChangeStatePromotedCommitted(InternalTransaction tx)\r\n at System.Transactions.InternalTransaction.DistributedTransactionOutcome(InternalTransaction tx, TransactionStatus status)\r\n at System.Transactions.Oletx.RealOletxTransaction.FireOutcome(TransactionStatus statusArg)\r\n at System.Transactions.Oletx.OutcomeEnlistment.InvokeOutcomeFunction(TransactionStatus status)\r\n at System.Transactions.Oletx.OutcomeEnlistment.Committed()\r\n at System.Transactions.Oletx.OletxTransactionManager.ShimNotificationCallback(Object state, Boolean timeout)\r\n at System.Threading._ThreadPoolWaitOrTimerCallback.PerformWaitOrTimerCallback(Object state, Boolean timedOut)&quot;</p> 2008-01-23T14:48:44-05:002008-01-23T14:48:44.627-05:00urn:uuid:00000000-0000-0000-0000-000002108361http://forums.asp.net/p/1205275/2108361.aspx/1?Multiple+foreign+keys+between+two+tablesMultiple foreign keys between two tables <p>I have been working on an issue tracking application and have decided to do my database access using linq. The only real problem I have run into is how to link two tables that have multiple foreign key relations.</p> <p>I have table [Issue] and table [User]. [Issue] has fields issue_creator_id and issue_assigned_id, both related to [User].</p> <p>The problem that I run into is that when I access Issue.User.user_name with linq, I cannot choose between the creator or assigned relationship.</p> <p>Other than creating a different User table in the dbml for each time I have multiple foreign keys, what can I do?</p> 2008-01-14T13:51:53-05:002008-01-14T13:51:53.413-05:00urn:uuid:00000000-0000-0000-0000-000001323382http://forums.asp.net/p/1002433/1323382.aspx/1?Code+Generation+ErrorCode Generation Error <p>I was so excited to try BLinq, but... After I ran the tool (no errors)&nbsp;and got web-site created, the generated code cannot be compiled:</p> <p><strong>Description: </strong><font face="Arial">An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. <br> <br> </font><b>Compiler Error Message: </b><font face="Arial">CS0100: The parameter name 'CONTAINERs_ID' is a duplicate<br> <br> </font><b>Source Error:</b><br> <br> <table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td></td> </tr> <tr> <td><pre class="prettyprint"><pre>Line 103: // This method gets sorted and paged records of all CONTAINERs filtered by a specified field.</pre> Line 104: // Do not change this method. Line 105: public static IQueryable&lt;CONTAINER&gt; GetCONTAINERs(string tableName, Int32 CONTAINERs_ID, Int32 CONTAINERs_ID, Int32 CONTAINERs_ID, string sortExpression, int startRowIndex, int maximumRows) { Line 106: IQueryable&lt;CONTAINER&gt; x = GetFilteredCONTAINERs(tableName, CONTAINERs_ID, CONTAINERs_ID, CONTAINERs_ID); Line 107: return x.SortAndPage(sortExpression, startRowIndex, maximumRows, &quot;ID&quot;); <pre></pre></pre></td> </tr> </tbody> </table> </p> <p>&nbsp;</p> 2006-06-23T19:16:06-04:002006-06-23T19:16:06.863-04:00urn:uuid:00000000-0000-0000-0000-000002092412http://forums.asp.net/p/1201511/2092412.aspx/1?Cross+dbml+RelationshipsCross dbml Relationships <p>Hi,</p> <p>Can I build relationships between classes in deferent dbml files so that the deferent namespaces can be used?</p> <p>Thx, :-)</p> 2008-01-06T01:12:41-05:002008-01-06T01:12:41.107-05:00urn:uuid:00000000-0000-0000-0000-000001360510http://forums.asp.net/p/1014374/1360510.aspx/1?Menu+text+truncationMenu text truncation <p>Some of my database tables have long, descriptive names like &quot;RateScheduleType&quot;.&nbsp; I added spaces in the title attributes of the sitemap file for readability, however, the menu items are truncated.&nbsp; For example, what should read &quot;Rate Schedule Types&quot; reads &quot;Rate Schedule Ty...&quot;, and instead of &quot;New Rate Schedule Type&quot;, the submenu reads &quot;New Rate Schedul...&quot;.&nbsp; I've been messing with the stylesheets to no avail.&nbsp; Any help would be appreciated.&nbsp; Thanks.</p> <p>Mike</p> 2006-08-03T21:40:14-04:002006-08-03T21:40:14.933-04:00urn:uuid:00000000-0000-0000-0000-000001370309http://forums.asp.net/p/1017415/1370309.aspx/1?The+transaction+has+already+been+implicitly+or+explicitly+committed+or+aborted+The transaction has already been implicitly or explicitly committed or aborted <p>Why does this error happen when I try to insert a new message?</p> <p>&nbsp;</p> <p>&nbsp;</p> <p><span></p> <h1>Server Error in '/LMBlinq' Application. <hr width="100%" color="silver" size="1"> </h1> <h2><i>The transaction has already been implicitly or explicitly committed or aborted (Exception from HRESULT: 0x8004D00E)</i> </h2> <p></span><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><b>Description: </b>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. <br> <br> <b>Exception Details: </b>System.Runtime.InteropServices.COMException: The transaction has already been implicitly or explicitly committed or aborted (Exception from HRESULT: 0x8004D00E)<br> <br> <b>Source Error:</b> <br> <br> <table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td><pre class="prettyprint"><pre>Line 31: LawMessage db = CreateDataContext();</pre> Line 32: db.Messages.Add(x); Line 33: db.SubmitChanges(); Line 34: return 1; Line 35: } <pre></pre></pre></TD></TR></TBODY></TABLE><BR><B><FONT face=Verdana>Source File: </FONT></B>c:\LMBlinq\NewMessage.aspx.cs<B><FONT face=Verdana> &nbsp;&nbsp; Line: </FONT></B>33 <BR><BR><B><FONT face=Verdana>Stack Trace:</FONT></B> <BR><BR> <TABLE width="100%" bgColor=#ffffcc> <TBODY> <TR> <TD><pre class="prettyprint"><PRE>[COMException (0x8004d00e): The transaction has already been implicitly or explicitly committed or aborted (Exception from HRESULT: 0x8004D00E)] System.Transactions.Oletx.ITransactionShim.Export(UInt32 whereaboutsSize, Byte[] whereabouts, Int32&amp; cookieIndex, UInt32&amp; cookieSize, CoTaskMemHandle&amp; cookieBuffer) +0 System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts) +211 [TransactionException: The transaction has already been implicitly or explicitly committed or aborted.] System.Transactions.Oletx.OletxTransactionManager.ProxyException(COMException comException) +326 System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts) +266 System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx) +379 System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx) +50 System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction) +47 System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction) +28 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1242 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +159 System.Data.DLinq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +38 System.Data.DLinq.SqlClient.SqlContext.get_IsServer2KOrEarlier() +31 System.Data.DLinq.SqlClient.SqlContext.Execute(Expression query) +351 System.Data.DLinq.SimpleChangeDirector.ExecuteInsert(TrackedObject item, StringBuilder changeText) +147 System.Data.DLinq.SimpleChangeDirector.Insert(TrackedObject item) +95 System.Data.DLinq.ChangeProcessor.SubmitChanges(ConflictMode failureMode) +234 System.Data.DLinq.DataContext.SubmitChanges(ConflictMode failureMode) +211 System.Data.DLinq.DataContext.SubmitChanges() +6 NewMessagePage.Insert(Message x) in c:\LMBlinq\NewMessage.aspx.cs:33 [TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +358 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 Microsoft.Web.UI.Controls.PageDataSourceView.InvokeMethod(PageDataSourceMethod method) +157 Microsoft.Web.UI.Controls.PageDataSourceView.ExecuteInsert(IDictionary values) +454 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +68 System.Web.UI.WebControls.DetailsView.HandleInsert(String commandArg, Boolean causesValidation) +392 System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +609 System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +88 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e) +109 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +86 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +153 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4917 </PRE></pre></td> </tr> </tbody> </table> <br> </p> <hr width="100%" color="silver" size="1"> <p><b><font face="Verdana">Version Information:</font></b>&nbsp;Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 </font></p> 2006-08-14T16:43:56-04:002006-08-14T16:43:56.837-04:00urn:uuid:00000000-0000-0000-0000-000002056520http://forums.asp.net/p/1193590/2056520.aspx/1?Customizing+Blinq+generated+Master+PagesCustomizing Blinq generated Master Pages <p>Is anyone familiar with customizing Blinq-generated Master Pages?&nbsp; I'm trying to use long table names, and the menu control on the master page truncates them.&nbsp; I tried using an example that narrows the menu control, but widening does not work for me.&nbsp; Any help from the Blinq forum would be helpful.&nbsp; Thanks.</p> <p>&nbsp;mj</p> 2007-12-12T22:35:59-05:002007-12-12T22:35:59.74-05:00urn:uuid:00000000-0000-0000-0000-000002001101http://forums.asp.net/p/1180847/2001101.aspx/1?BLinq+on+Beta2BLinq on Beta2 <p>hi,</p> <p>where can i find a copy of BLinq that will work with Beta 2?</p> <p>&nbsp;</p> <p>Regards</p> <p>gert</p> 2007-11-12T07:07:47-05:002007-11-12T07:07:47.197-05:00urn:uuid:00000000-0000-0000-0000-000001985648http://forums.asp.net/p/1177249/1985648.aspx/1?Updating+a+database+column+of+type+ntext+is+NOT+working+from+BLINQ+Updating a database column of type ntext is NOT working from BLINQ. <p>Hi All,</p> I&nbsp;am getting&nbsp;&quot;<strong><em>Value cannot be null. Parameter name:body</em></strong>&quot; &nbsp;error while updating ntext column in the database. The column attributes are <font size="2"></font><font size="2"> <p>[Column(Storage=</font><font color="#800000" size="2">&quot;_ShortDescription&quot;</font><font size="2">, UpdateCheck=System.Data.DLinq.UpdateCheck.Never, DBType=</font><font color="#800000" size="2">&quot;NText&quot;</font><font size="2"> )]</p> </font> <p>So, I changed the UpdateCheck to &nbsp;&quot;<font size="2"><strong>UpdateCheck=System.Data.DLinq.UpdateCheck.WhenChanged</strong>&quot; and got &quot;<strong>SQL Server does not handle comparison of NText, Text, Xml, or Image data types</strong> &quot;. Got the same error when the setting changed to &quot;<font size="2"><strong>UpdateCheck=System.Data.DLinq.UpdateCheck.Always</strong>&quot;</font></font></p> <p><font size="2"><font size="2"></font></font>&nbsp;</p> <p><font size="2"><font size="2">Any suggestions please</font></font></p> <p><font size="2"><font size="2"></font></font>&nbsp;</p> <p><font size="2"><font size="2">Thanks</font></font></p> <p><font size="2"><font size="2">Vijay</p> </font></font> <p>&nbsp;</p> 2007-11-01T18:56:24-04:002007-11-01T18:56:24.21-04:00urn:uuid:00000000-0000-0000-0000-000001945519http://forums.asp.net/p/1167457/1945519.aspx/1?DetailsView+wrong+displayDetailsView wrong display Hi. The DetailsView displays the Data fields wrong. When I click on NewWorkOrder it shows a dropdown list for my workorderID....this is supposed to be a text box and i must enter the ID. This is my primary key in the table. is there a way to fix this?? How can i change the template so that it works? thanks 2007-10-08T10:59:42-04:002007-10-08T10:59:42.207-04:00