Tagged Questions
3
votes
0answers
88 views
Database design to store and evaluate rules expression
I have a scenario where I need to assign some Items to a Guest.
GuestTable has columns like
1. Guest ID
2. GuestType
3. Age
4. Height
5. Gender
ItemTable has columns like
1. ItemID
2. Item Name
...
2
votes
0answers
61 views
SQL Express client memory usage differs to SQL Enterprise client memory usage
I am experiencing a big difference in .Net application memory usage using the same app against two copies of the same database. The only difference is that in scenario 1 I am using a local copy of ...
2
votes
0answers
113 views
can I use Entity Framework when the DBMS-type is not known at build time?
I'm developing an application (CRUD WS) that connects to single database that can be Oracle or SQL server and the type is read from configuration file. Can I use EF to implement DAL? Some ...
2
votes
0answers
347 views
Using “cursor with hold” on .NET towards SQL Server
In connection with a migration project, migrating data from DB2 to SQL Server I have run into a problem with the way the .NET provider towards DB2 uses (data) cursors.
Today the client is executing a ...
1
vote
0answers
19 views
What does the dbo.aspnet_schemaversions table exactly do?
I tried googling for an answer but I didn't find any direct reference. I know it's part of the membership provider. However, I don't find any relationships with other tables. No foreign key or ...
1
vote
0answers
28 views
How data provider fetch and submit data to the database server
What happen in the background when we execute any query from the .net application. I want to know the following particulars.
How providers take a query and send to DB Server and again fetch the ...
1
vote
0answers
60 views
Create a database table from a Type. In code. Simply
I've been looking to replace SqlCommand's with Entity framework or Linq-To-SQL. However, they seem to rely heavily on using the designer (which I rather minimize), and in the case of Linq-To-SQL it ...
1
vote
0answers
177 views
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint with Entity Framework
I have a table with a self reference where the ParentId is an FK to the ID (PK).
Using EF (code-first), I've set up my relationship as follows:
this.HasOptional(t => t.ParentValue)
...
1
vote
0answers
49 views
Error connecting to SQL Server via alias from local IIS7
Just wondering if anyone has run into this before. Had a few devs look at this, and none of us can figure it out.
I have an ASP.NET Web Forms app connecting to a Sql Server db via an alias using ...
1
vote
0answers
61 views
Cannot use id on column title when pivoting and colum values are mixed
In this query:
select *
from
(
select distinct a.id as 'Id Documento',
b.valor, 'index'+cast(row_number() over(partition by a.id order by b.idIndice) as varchar(10)) rn
from ...
1
vote
0answers
77 views
Cascading deletes on *Derived Entities*
OK, check out the following simple object model:
Entity ConcreteThingy derives from AbstractThingy.
Entity Owner can have at most 1 ConcreteThingy.
No two Owners can have the same ConcreteThingy.
...
1
vote
0answers
167 views
DbUpdateConcurrencyException on Unchanged entity
It appears that I am getting a concurrency exception on entities that are not modified. I am using Entity Framework 4.3.1, Code First, and this is happening in a WCF service.
To simplify my example, ...
1
vote
0answers
61 views
.net sql integration tests & full text catalog
I'm trying to write some integration tests for a part of our site that uses a stored procedure instead of running through EF.
We just want to ensure that the data that we get back from the stored ...
1
vote
0answers
288 views
Calling User Defined Function in Linq to SQL partial entity class
I have a user defined function sitting on my SQL server. I want to utilise this within one of the partial entity classes created by the Linq to SQL designer.
I know it's very simple to do when you ...
1
vote
0answers
109 views
NHibernate delete cascade without mapping the collection
This is somewhat strange question, but is there some way to make NHibernate delete all children on deleting parent, if the parent doesn't have reference to his children (by reference I mean concrete ...
