Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Worse case scenario, if you're service code references the DAL assembly in Visual Studio, is to open the WCF project/solution again, make sure the reference is up to date to the DAL (either by project reference or DLL reference) and rebuild / republish.</p> <p>There are likely better ways, but this should work as a fallback option...</p> <p><strong>EDIT:</strong></p> <p>To provide some feedback on perhaps a more efficient way to work with WCF development - here is how we work on these systems:</p> <ol> <li>External common libraries such as DAL, Core business assemblies, etc. are stored on the network (For example, under a UNC such as <code>\\DEVSTORE\CommonAssemblies\DAL\MyDal.dll</code>, etc.)</li> <li>In your WCF application in Visual Studio, add an actual reference to the DLLs on the network. The default settings will copy the dll locally to the bin folder during the build</li> <li>Use the publish feature in Visual Studio to output the svc, bin folder, web.config etc. to either a temporary folder or the IIS app folder itself.</li> <li>When working on the common DAL or other common libraries in VS, simply ensure when you build, you put a copy of the DLL to the common network location.</li> </ol> <p>Makes for a pretty simple dev experience. </p>
    singulars
    1. This table or related slice is empty.
    1. POWCF in IIS How do I update a dll in the bin folder?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKP.
    1. USKP.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWCF in IIS How do I update a dll in the bin folder?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COBy republish, you mean drop all the necessary files (interface file, service class file, and dll's) into the correct folder in IIS? The webservice project doesn't have any references added to it through the "add reference" option. The interface class and the service class both have a using statement for the DataAccessLibrary.dll though. Looking in the solution explorer, it does have a Bin folder with all of the dlls from other projects in the solution. This project was inherited which is why I don't know much about it.
      singulars
      1. PO
      1. UScyrix86
    2. COSo the DAL assembly must have been added manually to the bin folder for the WCF project in visual studio then, otherwise it never would have built (with the same error you stated)... If you have the WCF solution in VS, check the bin folder for the DLL, you may need to overwrite it there. What type of code changes did you make (i.e. new functionality, namespace changes, access level changes - private/public, etc.)?
      singulars
      1. PO
      1. USKP.
    3. COnothing like that, There is a method in the DAL library that queries a DB. All I did was add another "AND" condition to the SQL. I've verified that the code works. I have a windows service that uses the same DAL library and it works with no problem. The problem is that the DAL class name itself is not recoginized when called in the service.cs code. I will try overwriting the dlls in the Bin folder of the wcf project and then rebuild/deploy to IIS. I'll get back to you in a minute
      singulars
      1. PO
      1. UScyrix86
 

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