Databases
StackOverflow2013
Postsdbo
POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
    primarykey
    data
    text
    <pre><code>SELECT TOP 1000 [GUID] ,[Ticket_Number] ,[Created_At] ,[Changed_At] ,[Priority] ,[Department] ,[Ticket_Type] ,[Category] ,[SubCategory] ,[Second_Category] ,[Third_Category] ,[ZZARN] ,[Categorization_Hash_Key] ,[ZZAID] ,[Work_Order] ,[Contact_Type] ,[Action] ,[BPartner_Key] ,[PFT] ,[Ticket_Status_Code] ,[Ticket_Status] ,[Audit_Key] FROM [CorporateDWTest].[dbo].[SRS_Ticket_Transaction_Stage_Cleaned] </code></pre> <p>&amp; Design: <a href="http://i40.tinypic.com/2ufvshz.png" rel="nofollow">http://i40.tinypic.com/2ufvshz.png</a></p> <p>Ya i deleted everything else, if someone has any idea what the guy who posted an answer refers to in reference to my tables column name design and structure please feel free to answer.</p> <p>Class definition (That is inside of the Model1.Context.CS(.edmx)):</p> <pre><code>public DbSet&lt;SRS_Ticket_Transaction_Stage_Cleaned&gt; SRS_Ticket_Transaction_Stage_Cleaned { get; set; } </code></pre> <hr> <pre><code>namespace CorporateDWTesting { using System; using System.Collections.Generic; public partial class CRM_Ticket_Transaction_Stage_Cleaned { public byte[] GUID { get; set; } public string Ticket_Number { get; set; } public decimal Created_At_UTC { get; set; } public decimal Changed_At_UTC { get; set; } public string Priority { get; set; } public string Department { get; set; } public string Municipality { get; set; } public string Ticket_Type { get; set; } public string Category { get; set; } public string SubCategory { get; set; } public string Address_Number { get; set; } public string Street1 { get; set; } public string Street2 { get; set; } public string Contact_Type { get; set; } public string Action { get; set; } public string BPartner_Key { get; set; } public Nullable&lt;int&gt; PFT { get; set; } public string Ticket_Status_Code { get; set; } public string Ticket_Status { get; set; } public Nullable&lt;decimal&gt; Due_Date_UTC { get; set; } public int Audit_Key { get; set; } public virtual Dim_Audit Dim_Audit { get; set; } } } </code></pre> <p>Dim_Audit:</p> <pre><code>namespace CorporateDWTesting { using System; using System.Collections.Generic; public partial class Dim_Audit { public Dim_Audit() { this.Business_Partner_Stage = new HashSet&lt;Business_Partner_Stage&gt;(); this.CRM_Ticket_Transaction_Stage = new HashSet&lt;CRM_Ticket_Transaction_Stage&gt;(); this.CRM_Ticket_Transaction_Stage_Cleaned = new HashSet&lt;CRM_Ticket_Transaction_Stage_Cleaned&gt;(); this.Dim_Audit1 = new HashSet&lt;Dim_Audit&gt;(); this.Dim_Categorization = new HashSet&lt;Dim_Categorization&gt;(); this.Dim_Collection_Type = new HashSet&lt;Dim_Collection_Type&gt;(); this.Dim_Municipality = new HashSet&lt;Dim_Municipality&gt;(); this.Dim_Response_Team = new HashSet&lt;Dim_Response_Team&gt;(); this.Dim_Ticket = new HashSet&lt;Dim_Ticket&gt;(); this.Fact_Service_Units = new HashSet&lt;Fact_Service_Units&gt;(); this.Fact_Service_Units1 = new HashSet&lt;Fact_Service_Units&gt;(); this.Fact_Ticket_Processing = new HashSet&lt;Fact_Ticket_Processing&gt;(); this.Fact_Ticket_Processing1 = new HashSet&lt;Fact_Ticket_Processing&gt;(); this.Initial_Categories = new HashSet&lt;Initial_Categories&gt;(); } public int Audit_Key { get; set; } public Nullable&lt;int&gt; Parent_Audit_Key { get; set; } public string Table_Name { get; set; } public string Package_Name { get; set; } public Nullable&lt;System.Guid&gt; Package_GUID { get; set; } public Nullable&lt;int&gt; Package_Version_Major { get; set; } public Nullable&lt;int&gt; Package_Version_Minor { get; set; } public Nullable&lt;System.DateTime&gt; Execution_Start_Time { get; set; } public Nullable&lt;System.DateTime&gt; Execution_End_Time { get; set; } public Nullable&lt;int&gt; Extract_Row_Count { get; set; } public Nullable&lt;int&gt; Insert_Row_Count { get; set; } public Nullable&lt;int&gt; Update_Row_Count { get; set; } public Nullable&lt;int&gt; Error_Row_Count { get; set; } public Nullable&lt;int&gt; Table_Initial_Row_Count { get; set; } public Nullable&lt;int&gt; Table_Final_Row_Count { get; set; } public Nullable&lt;int&gt; Table_Max_Surrogate_Key { get; set; } public string Table_Max_Business_Key { get; set; } public Nullable&lt;bool&gt; Processing_Successful { get; set; } public string Error_Code { get; set; } public virtual ICollection&lt;Business_Partner_Stage&gt; Business_Partner_Stage { get; set; } public virtual ICollection&lt;CRM_Ticket_Transaction_Stage&gt; CRM_Ticket_Transaction_Stage { get; set; } public virtual ICollection&lt;CRM_Ticket_Transaction_Stage_Cleaned&gt; CRM_Ticket_Transaction_Stage_Cleaned { get; set; } public virtual ICollection&lt;Dim_Audit&gt; Dim_Audit1 { get; set; } public virtual Dim_Audit Dim_Audit2 { get; set; } public virtual ICollection&lt;Dim_Categorization&gt; Dim_Categorization { get; set; } public virtual ICollection&lt;Dim_Collection_Type&gt; Dim_Collection_Type { get; set; } public virtual ICollection&lt;Dim_Municipality&gt; Dim_Municipality { get; set; } public virtual ICollection&lt;Dim_Response_Team&gt; Dim_Response_Team { get; set; } public virtual ICollection&lt;Dim_Ticket&gt; Dim_Ticket { get; set; } public virtual ICollection&lt;Fact_Service_Units&gt; Fact_Service_Units { get; set; } public virtual ICollection&lt;Fact_Service_Units&gt; Fact_Service_Units1 { get; set; } public virtual ICollection&lt;Fact_Ticket_Processing&gt; Fact_Ticket_Processing { get; set; } public virtual ICollection&lt;Fact_Ticket_Processing&gt; Fact_Ticket_Processing1 { get; set; } public virtual GIS_Collection_Stage GIS_Collection_Stage { get; set; } public virtual ICollection&lt;Initial_Categories&gt; Initial_Categories { get; set; } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat happens if you place a breakpoint on that rule. What is the value of `SRS_Ticket_Transaction_Stage_Cleaned` inside of the `context` object?
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. USHenk Jansen
    2. COif I place a breakpoint on the statement that causes the error the error still shows, and if I hover over context within that statement it says "local variable mydb context"
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. This table or related slice is empty.
    3. COCan you show us the `CorporateDWTestEntities1` class as well? since that seems to be your `context`
      singulars
      1. POError Inside Of Visual Studio 2012 - " '.' or '(' expected "
      1. USHenk Jansen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload