I'm having a strange problem here. I'm trying to connect to a remote SQL
Server database but I keep getting this error:
An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that

I get the exception: “An entity object cannot be referenced by multiple
instances of IEntityChangeTracker” when I attempt to attach my object to my
context.
Here's my code

The following statement does not eager load the 1:n related Offices property.
  var q = from Company c in ctx.Companies.Include("Offices") select c;
If not using the query language but instead using the Linq to Entities
extension methods, eager loading works fine:

How can I
1. Check if the current record in BindingSource has been edited, deleted or
added, and
2. Save this particular (current) record only, instead of all records

I have created a drag and drop form a single table using vs2008.
I have added several queries to the table adapter in Dataset designer. Is
there any way for binding source to use relevant queries separately i.e. for
BindingSource.MoveNext to use FillNext/GetDatNext query and

I'm having problems inserting records using what I thought was a rather
common technique.  The table is on my local machine, I'm the admin and I'm
using windows authentication.   All I want to do is loop through another
table elsewhere and insert a few records into the target.  ...

Would somebody at Microsoft care to explain why, when constructing a URI for
use by ADO.Net Data Services, I have to use this type of syntax with
startswith() and endswith():
sbrUri.AppendFormat("$filter=endswith(ProductName,'{0}')&", productName);

I have a form with a bunch of bound text boxes. It works perfectly. I added a
new bound text box. This bound field was already in the dataset, except it
was not used. When I try to save the data, it clears the data in this new
field. It saves all the other textboxes that were ...

I have been given what seems a simple task, but in developing the app, it's
turning out to be not quite so simple...  I am writing this app as a WinForm
in VB.NET VS2005.
Here's some pseudo-code for what my app has to do...

Post Replies in this dotnet forum and get gifts daily
www.dotnetforall.com
come :: register :: login :: win

I'm really struggling here to work out how to do nested transactions with my
asp.net 2.0 web application, connected to a sql server database.
If I try to begin a second transaction on my transaction object I get the
error "SQL connection does not support parallel transactions".

How can I convert data from Dataset to an XML Document in memory?

I have a strongly typed dataset which I serialize to XML using the
DataTable.WriteXML() function, and read using the DataTable.ReadXML()
function.
I am now going to have to make a change to the schema definition.

I´ve a n tier application.
I´ve a data model using enttity framework and a bussines tier that publish
their services using WCF.
by example:

I have the following environment:
Visual Studio 2003 / .NET 1.1
SQL Server 2000 Developer version, with Analysis Services.
I am having difficulty connecting to my cube from .NET. I CAN connect