0
votes
0answers
43 views
High performance real time project .NET, SQL Server
I have a demanding project and I need your starting guidelines on this!
I need to have a database with approximately 2.000.000 records with markers lat,lng. These markers are moving objects and ...
0
votes
3answers
24 views
Sql database copy from one server to another server
I am just looking for some advice here as I am quite new to this. I have a client who requires a local copy of a SQL database and the same database running on a remote server. the remote database is ...
0
votes
1answer
18 views
Is it possible to iterate multiple data sets async BeginExecuteReader?
I have a long running stored procedure that returns multiple results.
I'd like to iterate the results asynchronously and grab results as they are ready (AS THEY ARE AVAILABLE).
ExecuteReaderAsync ...
0
votes
0answers
11 views
Can't call End Conversation through the Service Broker on all entities?
I am using the Service Broker on SQL Server 2008 R2, and I am registering a query that is joining multiple tables like this:
SELECT
A.Date
,A.Id
,P.LastName
FROM
dbo.Appointment A
...
0
votes
2answers
37 views
Automatically set added properties when retrieving database objects in C#
I am extending a large C# project that connects to SQL Server.
In the database I have an Inventory table which has a foreign key manufacturer_id from the Manufacturer table.
I have added some ...
0
votes
1answer
35 views
Bind Value with asp:Label without knowing the Column Name
I am currently binding the data with an asp:NET label as following:
<ItemTemplate>
<asp:Label ID="hhmIdLabel" runat="server" Text='<%# Eval("name") %>'/>
</ItemTemplate>
...
-1
votes
0answers
24 views
Map DB tables by entities structure and relationships [on hold]
In my workplace we use couchbase to save all our data because we need to work with a lot of users and information.
We also have BI team that needs to create statistics on some of the information we ...
0
votes
2answers
29 views
How to handle ClientId in multi-tenant database
I have a multi-tenant database with strict and critical data separation between clients. Before putting it into production, I would like to know if my approach makes sense or could lead to problems ...
2
votes
1answer
38 views
would it be faster to parse XML from url or to save the informations in a database
I am relatively new to the development of a website with asp.net (C#) and SQL server 2008 (until now I was using php/mySQL). And I am currently facing some choices and any suggestion to help me make ...
1
vote
3answers
27 views
Select all tags that are user in questions asp.net c# EF
There are four tables:
Questions(questionId, question)
QuestionTags(questionTagId, questionId, tagId)
CodingKeys(codingKeyId, codingTypeId ..)
Codings(codingId, codingKeyId, coding ..)
I want to ...
0
votes
1answer
18 views
Storing an image into the SQLserver in windows store app
I'm new to windows 8 app development. I'm using XAML and C# for it. I'm using file picker to select an image. Now i want to store this image onto the SQLserver database. But the problem is there is no ...
0
votes
3answers
54 views
How to control Concurrency to update 3 database tables
When i click save button on the form
it calls 3 methods:
save_Purchase();
save_dtPurcaseProduct();
save_dtPurchaseProductExp();
these 3 methods save changes to 3 database tables
so the scenario ...
0
votes
0answers
23 views
Nested Gridview with checkboxes errors
As I was working on getting an Ajax based CollapsiblePanelExtender solution this past week (as noted in this previous SO post) it dawned on me that the code for a Nested Gridview was anything but ...
0
votes
5answers
38 views
SqlCommand select from where issue
I have got this code below which should:
Select column odjezd
From table stanice
Order by odjezd
where akce=zakce.Text
SqlCommand combobox = new SqlCommand("SELECT odjezd FROM stanice
...
0
votes
0answers
14 views
Updateable Subscriptions: Rows do not match between Publisher and Subscriber
I have transactional replication with updatable subscribers set up in SQL Server 2008. It has 3 subscribers and 1 publisher. I had to setup replication again due to some errors related to the database ...
