Tagged Questions

0
votes
2answers
249 views

WCF Dataservices Insert into multiple tables

So I have got my WCF Dataservice up and running, but I wanted to be able to insert into multiple tables - Would be easier to explain with a simple example: Tables: tbl_Shop ShopID (primary key) ...
0
votes
1answer
63 views

Sync Hub and Spoke model with SQL Server Express on server and clients

I have been researching on how to sync clients SQL Server Express to a central SQL Server Express. At first I looked at Replication but the only issue is that replication is not supported if the ...
0
votes
1answer
119 views

WCF Odata Service w3wp Process Memory Creap

I'm a little confused at the memory use of my WCF service. Brief overview, my wcf service is an odata providor that allows my ipad application to talk to our sql server database. The problem is that ...
2
votes
1answer
109 views

Linq query combining ADO.Net entities from a database connection and a data service reference?

I'm not even quite sure how to properly word this, but here goes. I have two .net web applications. One provides a WCF data service ("DEPT_DataService") which provides access to a number of entity ...
0
votes
2answers
149 views

Error in SQL Server to WCF development

I am testing a DB that have two tables (Satellite and Channel) to be exposed as I need using WCF. fortunately, I tried everything I know and online for more that I week now and I can't solve the ...
1
vote
1answer
329 views

WCF Data Services updating entity error and type of table's primary key

For some time I couldn't find out the cause of an error when trying to update a field in a table using WCF Data Services plus Entity Framework: MydbEntities context = new MydbEntities(new ...
1
vote
1answer
91 views

Stress test in a Silverlight application, which consumes data from a WCF DataService then exposes data from a SQLServer Database

I´m deploying a Silverlight application, which consumes data from a WCF DataService then exposes data from a SQLServer Database. Everytyhing works fine, but I´d like to make some stress tests. It´s ...
2
votes
1answer
105 views

hardware requirements for small Silverlight application, which consumes data from a WCF DataService than exposes data from a SQLServer Database

I´m deploying a small Silverlight application, which consumes data from a WCF DataService then exposes data from a SQLServer Database. The expected number of visitors of my the site is a few ...
0
votes
1answer
380 views

Creating WCF Data Services from a Database

At the moment I have a website that is connecting to the database the old fashion way, ie through stored procs from a back-end. Now I wish to change all this to services, so that I can consume this ...
0
votes
1answer
692 views

Dynamic query data from WCF Data Service to Silverlight Application?

I have a Silverlight application that contains a window that lists several values in multiple columns. The first column contains fields to be retrieved from a database, the second column contains ...
0
votes
1answer
193 views

Sync framework with WCF Data Services

I've got SQL Server 2008 database on the server and SQL CE 4.0 database on the clients. Server and client communicate using WCF Data Services. How can I sync these databases through data services?
0
votes
1answer
522 views

How best to filter entities exposed by ado.net data services on top of entity framework?

I want to expose a simple set of blog posts, tags and categories through an API provided by ADO.NET data services. It looks easy in the demos: create your entity data model using the entity framework ...
4
votes
3answers
3k views

Libraries for ADO.NET to rapidly bulk insert data into a database from a .csv file?

I'd like to know if you can recommend any advanced ADO.NET libraries for working with databases. I've discovered that LINQ-to-Entities is great for pulling data out of databases, but not at all ...
1
vote
2answers
688 views

Native XML Web Services for SQL Server 2008

I want to share a few small tables from my SQL Server 2008 database. Client is html/javascript based. I started with Native XML Web Services for SQL Server, but it's deprecated in SQL Server 2008. ...
2
votes
2answers
353 views

SQLCLR trigger vs Windows service. When is it appropriate to use SQLCLR?

We have a .NET e-commerce application with a SQL Server 2005 back-end. A new order requires certain "post-processing". These tasks include sending emails, creating files, uploading files to an FTP ...