Añadir Vista a Entity Framework sin Primary Key

En ocasiones no podemos añadir una Vista de SQL Server a nuestro modelo de Entity Framework y nos dice que es porque la vista no contiene ninguna "Key". Para resolver este problema debemos tener en cuenta que No se pueden crear Primary Keys en Vistas. La solución para por crear una columna nueva autonumérica. Seguiremos …

Sigue leyendo Añadir Vista a Entity Framework sin Primary Key

Windows Server 2012: Configure Active Directory in 14 Steps

1. Add Role from Server Manager 2. Role-based or feature-based installation 3. Select a server from the server pool 4. Select Active Directory Domain Services and DNS Server. 5. Once installed, from Notifications Menu, select Promote this server to a domain controller 6. Add a new Forest 7. Write a password 8. Next 9. Check …

Sigue leyendo Windows Server 2012: Configure Active Directory in 14 Steps

Export SQL query to CSV

1. Execute your Query with "Results to Grid" option selected (You can select this option with its icon or by menu "Query - Results To - Results to grid"). 2. Once your Query has finished, right-click on the results grid and select the option "Save results As...". 3. Save as Type: CSV.